2 Replies Latest reply: Apr 21, 2016 4:47 PM by Subba Reddy RSS

    KPI is not working in QlikSense.

    Subba Reddy

      Hi Folks,

       

      I have a Temp Filter - Critical,Hot,Wild,Harm

       

      when i select Critical, i want to show the Critical value in 2KPI's

       

      please find the below queries..

       

      Q1:-

      =IF(Count({<Temp={'Critical','Hot'},[Type 1 Count]={'1'},WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}Ticket)>0,

      Count({<Temp={'Critical','Hot'},[Type 1 Count]={'1'},WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}Ticket))

       

      Q2:-

      =IF(Count({<[Type 1 Count]={'1'},WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}Ticket)>0,

      Count({<[Type 1 Count]={'1'},WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}Ticket))

       

      It was showing wrong values, Please correct me where i did mistake

       

      sub2u444