none
Feature "QlikView Associtive search" in Excel Power View?

    Question

  • Hi all,

    I am looking for a feature like Associtive search in QlikView? I looked into Slicers (not similar to associtive search) and Highlighting (only for charts), but it does not provide the same functionality.

    Any ideas?

    Regards,

    Daniel

    Thursday, July 11, 2013 11:35 AM

Answers

  • Hi Gerhard,

    the "Associative Search" of QlikView is described best in this video:

    http://www.youtube.com/watch?v=keo5hq5-AfE

    In my point of view the feature "you still see the data which is excluded by the filters" gives the user a huge insight in his data.

    Regards,

    Daniel

    Hi Daniel,

    Thanks for your question. SQL Server 2012 Power View report doesn't provide such functionality, such as "Associative Search" in QlikView. We can dynamic to filter Power View report via Filter functionality.

    I recommend you that submit a feedback at https://connect.microsoft.com/SQLServer/. If the suggestion mentioned by customers for many times, the product team may consider to add the feature in the next SQL Server version.

    Best Regards,


    Elvis Long
    TechNet Community Support

    Tuesday, July 16, 2013 5:49 AM

All replies

  • could you explain what "Associtive search" in QlikView does from a functional Point of view?

    there is a search-functionality in PivotTable-filters and also in PowerView-(page-)filters


    - www.pmOne.com -

    Monday, July 15, 2013 7:48 AM
  • Hi Gerhard,

    the "Associative Search" of QlikView is described best in this video:

    http://www.youtube.com/watch?v=keo5hq5-AfE

    In my point of view the feature "you still see the data which is excluded by the filters" gives the user a huge insight in his data.

    Regards,

    Daniel

    Monday, July 15, 2013 8:04 AM
  • well, in PowerView you can only search within one column - not globally in all columns

    in Terms of filters you should only see items that have values related to other selected filters
    or do you want the opposite to also see items without data?

    e.g. you filter by "continent=Europe"
    there are countries like "Austria", "Germany", "Switzerland" of which not all have values - lets say only "Austria" has real values

    would you expect to see
    1) only "Austria" - as it is the only item with values
    2) "Austria", "Germany" and "Switzerland" - as the all are in "Europe"?
    3) all countries irregardless of the filter on Continent=Europe?


    - www.pmOne.com -

    Monday, July 15, 2013 10:06 AM
  • I attached the following example of the QlikView tutorial. If you select green, you get Apple and Lime (because these entries match) and you can still see Banana (in grey - which is not part of the result). Because of this feature the user can get some nice insights of his data, if the example extends the fruit business case ;-)

    Any ideas?

    Monday, July 15, 2013 1:27 PM
  • Hi Gerhard,

    the "Associative Search" of QlikView is described best in this video:

    http://www.youtube.com/watch?v=keo5hq5-AfE

    In my point of view the feature "you still see the data which is excluded by the filters" gives the user a huge insight in his data.

    Regards,

    Daniel

    Hi Daniel,

    Thanks for your question. SQL Server 2012 Power View report doesn't provide such functionality, such as "Associative Search" in QlikView. We can dynamic to filter Power View report via Filter functionality.

    I recommend you that submit a feedback at https://connect.microsoft.com/SQLServer/. If the suggestion mentioned by customers for many times, the product team may consider to add the feature in the next SQL Server version.

    Best Regards,


    Elvis Long
    TechNet Community Support

    Tuesday, July 16, 2013 5:49 AM