Set Analysis -- Need Help

[paulwalker]

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]

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]

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]

Is SalesID and EmpName coming from two different tables?

[paulwalker]

Yes Sunny.. i.e also concatenated both tables

[sunny_talwar]

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

[juraj_misina]

Hi Paul,

maybe this post can help Excluding values in Set Analysis

Best

Juraj

[paulwalker]

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

but both expression giving different output.

[sunny_talwar]

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)