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 given below expression in set analysis expression
Count(Distinct if(MonthName=KPIMonth and STATUS='CLOSED', bl_no))
I am writing
Count( Distinct {$<MonthName={'$(KPIMonth)'} ,STATUS={"CLOSED"}>} bl_no)
but its not working
try this...
Count({$<MonthName=P({1<KPIMonth={}>}MonthName),STATUS={'CLOSED'}>}bl_no)
TRY THIS
Count( Distinct {$<MonthName={'$(KPIMonth)'} ,STATUS={'CLOSED'}>} bl_no)
OR TRY THIS
Count(Distinct {$<MonthName=P({1<KPIMonth={'*'}>}MonthName)>}bl_no)
Try this
count( {$<MonthName = p({1<KPIMonth={'**'}>}MonthName)>},STATUS={'CLOSED'}>}distinct bl_No)
Try: Count({$<MonthName={'=MonthName=KPIMonth'},STATUS={'CLOSED'}>} Distinct bl_no)