Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert expression to set analysis

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

4 Replies
AbhijitBansode
Specialist
Specialist

try this...

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

Not applicable
Author

TRY THIS

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

OR TRY THIS

Count(Distinct {$<MonthName=P({1<KPIMonth={'*'}>}MonthName)>}bl_no)

er_mohit
Master II
Master II

Try this

count( {$<MonthName = p({1<KPIMonth={'**'}>}MonthName)>},STATUS={'CLOSED'}>}distinct  bl_No)

Gysbert_Wassenaar

Try: Count({$<MonthName={'=MonthName=KPIMonth'},STATUS={'CLOSED'}>} Distinct bl_no)


talk is cheap, supply exceeds demand