topic Re: Convert expression to set analysis in QlikView

Convert expression to set analysis

Thu, 09 May 2013 09:19:04 GMT

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

AbhijitBansode — Thu, 09 May 2013 09:29:05 GMT

try this...

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

Thu, 09 May 2013 09:33:12 GMT

TRY THIS

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

OR TRY THIS

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

er_mohit — Thu, 09 May 2013 09:39:19 GMT

Try this

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

Gysbert_Wassenaar — Thu, 09 May 2013 10:12:08 GMT

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