3 Replies Latest reply: Apr 28, 2015 9:34 AM by Matthias Brink RSS

    Use filter selection in expression (Qlik Sense)

      Hi.

       

      I'm new to Qlik Sense and I'm trying to use the values of the filter selection in an expression to calculate a measure

       

      e.g. Filter on 8 of 12 Months (JAN - AUG) => calculation would be something like SUM[RecordedDays] / (COUNT[Months.Selected] * 15) =>100 / ( 8 * 15) [Note: Month.Selected should be the expression to use the value of the filter pane]

       

      Any recommendations? Thanks.

       

      Marco