5 Replies Latest reply: Nov 10, 2015 7:13 AM by Sunny Talwar RSS

    FirstSortedValue not work in KPI box (Qlik Sense)

    Enikö Karlecz

      Hi, a FirstSortedValue expression does not work for me in KPI box but does work in Text Box:

       

      FirstSortedValue(agegroup, -Aggr(sum({$<ON_OFF= {'ON'}>} counter), agegroup) )

       

      It is an acceptable workaround, however, all other KPI-s are in KPI box and I cannot format the 2 boxes exactly the same. (text and KPI)

       

      Any ideas? thanks a lot!

       

      Enikö