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)

[kumarnatarajan]

Hi,

Exactly i don't know what you want.Try this one:

vKPIMonth=  Concat(DISTINCT '"'&KPIMonth&'"',',')

Create this to variable then use below Exp

  Ex: Count( Distinct {$<MonthName={$(vKPIMonth)} ,STATUS={"CLOSED"}>} bl_no)

[thomas_skariah]

Hi Jolly,

You can try this code

count({$<MonthName={'$(vKPIMonth)'},STATUS={"CLOSED"}>}DISTINCT  bl_no)

Regards,

Tom

[#4]

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