Convert expression to set analysis

[ajayagraa]

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)

[juleshartley]

Hi,

I assume 'KPIMonth'  is a variable? I think it might be that you need another '=' in the monthname bit... try this

=

          Count(distinct

          {$

          <

          MonthName= {"=$(KPIMonth)"}

          ,STATUS={"CLOSED"}

          >

          }

          bl_no

          )

Any good?