topic Re: Distinct in Set Analysis in QlikView

Distinct in Set Analysis

Thu, 24 Apr 2014 15:42:37 GMT

Hi guys,

I am trying to do a set analysis for a distinct month, could you help me sort it?

=if(Headcount<>Null(), count({<Month={'Jan'}>}distinct Employee))

Thanks,

Anna

MK_QSL — Thu, 24 Apr 2014 15:44:57 GMT

May be

Count({<Month={'Jan'}, Headcount = {*}>}Distinct Employee))

PrashantSangle — Thu, 24 Apr 2014 15:47:37 GMT

Hi,

Try this,

create flag in your script.

if(isnull(Headcount),'false','true') as Headcount_Flag;

Then use set analysis

like this,

count({<Month={"Jan"},Headcount_Flag={'true'}>} Distinct Employee)

regards,

its_anandrjs — Thu, 24 Apr 2014 15:59:33 GMT

Try like

=count({<Month={"Jan"},Headcount = {'$(=len(Headcount)<>0)' }>} Distinct Employee)

=count({<Month={"Jan"},Headcount = {*} >} Distinct Employee)

Thu, 24 Apr 2014 16:15:07 GMT

Thank you!