7 Replies Latest reply: Dec 19, 2017 7:50 PM by kong ch RSS

    Qlik Sense KPI second expression

    kong ch

      Dear all,

       

      I would like to create the second expression based on the same set of the data,

       

      the below first expression is about the highest total quantity among the 30 order date (or within period).

      say, the highest total quantity is on 21 Aug 2017 in Aug 2017

       

      Max(Aggr(sum({$<item={'ABC'}>}[Quantity]), [Order Date]))

       

       

      how can I get the 21 Aug 2017 as second expression in KPI?

       

       

      Thank you so much