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,
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?