3 Replies Latest reply: Apr 22, 2016 5:58 AM by Sunny Talwar RSS

    SetAnalysis Expr checking in Qliksense

    Subba Reddy

      Hi,

       

      Please find the below query.

       

      =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))

       

      ** if i select Temp as "Critical" -> It was showing Hot Count

      ** if i select Temp as "Hot" -> It was showing Critical & Hot Count


      please check..


      Sub2u444