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

    Convert expression to set analysis

      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)