2 Replies Latest reply: Aug 16, 2016 8:08 AM by Ralf Becher RSS

    KPI expression

    Madeleine Josefsson

      Hi,

      I would like to create a KPI that uses my value 'claimed' but QlikSense will not let me use the following expression. Can you please help to correct it?

       

      RangeSum(Count({<claimed > {1}>} AssignmentNo))/Count(AssignmentNo)

       

      I want the KPI to count how many of the assignments that have a claimed value higher than or equal to 1.

       

      Thanks!