Distinct in Set Analysis

[#1]

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 · Accepted solution]

May be

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

[PrashantSangle]

Hi,

Try this,

create flag in your script.

Like

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]

Try like

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

Or

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

[#5]

Thank you!