Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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)
Hi Jolly,
You can try this code
count({$<MonthName={'$(vKPIMonth)'},STATUS={"CLOSED"}>}DISTINCT bl_no)
Regards,
Tom
=Count({$<MonthName={'$(KPIMonth)'} ,STATUS={"CLOSED"}>} distinct bl_no)