0 Replies Latest reply: Oct 25, 2017 11:14 AM by Mohammad Sarif RSS

    Aggr is not working Properly

    Mohammad Sarif

      Hi All,

       

      I am using single KPI in Qlik sense.

      When I am using below expression then it is showing correct data:

      if(sum({$<Z_DATE=,Holiday_HD ={'Y'}, PLANT_HD -= {'All'},M_DATE={">=$(=(Date(Date#('$(vDATE)','M/D/YYYY') - 90)))<=$(=(Date(Date#('$(vDATE)','M/D/YYYY') - 1)))"}>} ORD_LINE_CNT)>0,'0','1')


      however when I am using below expression it is showing 0.

       

      sum(Aggr(if(sum({$<Z_DATE=,Holiday_HD ={'Y'}, PLANT_HD -= {'All'},M_DATE={">=$(=(Date(Date#('$(vDATE)','M/D/YYYY') - 90)))<=$(=(Date(Date#('$(vDATE)','M/D/YYYY') - 1)))"}>} ORD_LINE_CNT)>0,'0','1'),M_DATE))


      Can anyone please help me resolve this.

       

      Thanks in advance,

      Sarif