topic Re: Null in Set Analysis ? in QlikView

Null in Set Analysis ?

Thu, 27 Nov 2014 12:19:33 GMT

HI All,

I Need to Calculated Blank values in CusGrp by Using Set Analysis, I am getting If I am Using any Specific CusGrp, BUt I need for Blank CusGrp...

Ex: sum({<CusGrp={"OEM"}>}Amt)

CusGrp Amt

OEM 1000

OEM 2050

- 3000

LIGHT 4560

- 2000

LIGHT 3000

Regards,

Heather

Re: Null in Set Analysis ?

tresB — Thu, 27 Nov 2014 12:34:59 GMT

If it is really a null(), you won't be able to capture that in set analysis. You should probably replace the null values in the script by specific symbol or text, may be like:

Set NullAsValue CusGrp;

Set NullValue ='Null';

And then you would be able to filter them in set analysis like:

sum({<CusGrp={"Null"}>}Amt)

Re: Null in Set Analysis ?

anbu1984 — Thu, 27 Nov 2014 12:38:42 GMT

=sum({<CusGrp={'OEM'}>}Amt) + sum({1-<CusGrp={'*'}>}Amt)

sum({1-<CusGrp={'*'}>}Amt) -- Calculates sum of Amt where CusGrp is null

Re: Null in Set Analysis ?

ali_hijazi — Thu, 27 Nov 2014 12:43:23 GMT

or you can do sum(if(isnull(CusGrp),Amt))

Re: Null in Set Analysis ?

Thu, 27 Nov 2014 12:57:46 GMT

Now I am getting Value , but Amt is Differnt...

please let me know

Re: Re: Null in Set Analysis ?

anbu1984 — Thu, 27 Nov 2014 13:02:48 GMT

Check this app.

Note: Used Set Nullinterpret=''; in Script