3 Replies Latest reply: Aug 14, 2016 12:16 PM by Petr Bednarik RSS

    How to filter based on expression values (i.e. measures)?

    Petr Bednarik

      Hi,

       

      I would like to be able to explore (meaning of do selections/filter) my data not only based on the data present in the original files but also based on expressions/measures which I create as part of the Qlik Sense App. Especially expressions involving aggregations such as counts and sums (example below). Is there any easy way to do that? I know I can pre-calculate the expressions/aggregations as part of the data load script but that is cumbersome and limits how people can explore the data up-front.


      Example:

      I have a file of user movie ratings (UserID, MovieID, Rating). I would like to look at only movies which have been reviewed by at least 5 people. I would like to be able to filter by MovieIDs where Count(Rating)>=5.

       

      Thanks,

      Petr