topic Re: Convert expression to set analysis in QlikView

Convert expression to set analysis

ajayagraa — Mon, 26 Jan 2026 18:19:17 GMT

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 — Fri, 10 May 2013 08:35:06 GMT

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 — Fri, 10 May 2013 08:38:06 GMT

Hi Jolly,

You can try this code

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

Regards,

Tom

Fri, 10 May 2013 08:46:25 GMT

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