topic Re: Set Analysis -- Need Help in QlikView

Set Analysis -- Need Help

paulwalker — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

I have expression..

Count({<Type = {'A'},Indicator= {'India'}>} if(Audit <> 'Competency' and isnull(EmpName) ,SalesID))

I have converted into Set Analysis..

Count({<Type = {'A'},Indicator= {'India'}, Audit-={'Competency'}, EmpName-={'*'}>} SalesID)

But, this is not working properly.... did i anything wrong ??

Please help me!!

Thanks in Advancee

sunny_talwar — Wed, 10 Jan 2018 15:40:43 GMT

I think problem is with set analysis on EmpName.... you can't really select on null fields... try this instead

Count({<Type = {'A'},Indicator= {'India'}, Audit-={'Competency'}, SalesID = {"=Len(Trim(EmpName)) = 0"}>} SalesID)

paulwalker — Wed, 10 Jan 2018 15:52:52 GMT

Hi Sunny,

Not working, i'm getting two different values.

if i use IF condition working fine, converting to SET not coming correct.

sunny_talwar — Wed, 10 Jan 2018 15:56:46 GMT

Is SalesID and EmpName coming from two different tables?

paulwalker — Wed, 10 Jan 2018 15:59:00 GMT

Yes Sunny.. i.e also concatenated both tables

sunny_talwar — Wed, 10 Jan 2018 16:01:16 GMT

Oh so within QlikView they reside in the same table? And did you concatenate or did you join?

juraj_misina — Wed, 10 Jan 2018 23:26:08 GMT

Hi Paul,

Best

Juraj

paulwalker — Fri, 12 Jan 2018 08:40:11 GMT

Sorry, it was my bad, both are coming in same table.

but both expression giving different output.

sunny_talwar — Fri, 12 Jan 2018 08:50:18 GMT

May be create a flag in the script

If(Len(Trim(EmpName)) = 0, 1, 0) as Null_EmpName_Flag

and then this

Count({<Type = {'A'},Indicator= {'India'}, Audit-={'Competency'}, Null_EmpName_Flag = {'1'}>} SalesID)