3 Replies Latest reply: May 10, 2013 4:46 AM by Thomas Jensen RSS

    Convert expression to set analysis

    Ajay Verma

      HI All


      I am new to qlik view can anyone tell me how can i convert my expression given below to set analysis expression


      Count(Distinct if(MonthName=KPIMonth and STATUS='CLOSED', bl_no))


      I have used this but not working


      Count( Distinct {$<MonthName={'$(KPIMonth)'} ,STATUS={"CLOSED"}>} bl_no)