topic Re: Set Analysis and Nulls in QlikView

Set Analysis and Nulls

stevegimbrollmt — Wed, 29 Jan 2014 18:11:15 GMT

Hi there,

I admit I always get confused with Nulls within Set Analysis.

Basically I got this situation, I got these rows, RECEIVED_DATE, ASSUM_CONSUM and DVALUE

I want the Sum of DVALUE and want to get all the NULL Values from RECEIVED_DATE and All the Values which are NOT NULL in ASSUM_CONSUM.

Any suggestions on how to do it?

Would I be on the right track if I do something like

Sum({-<RECEIVED_DATE={*}>}DVALUE)

Thanks a lot Steve

Re: Set Analysis and Nulls

Carlos_Reyes — Wed, 29 Jan 2014 18:29:16 GMT

I think this document will help you.

NULL handling in QlikView

Re: Set Analysis and Nulls

Wed, 29 Jan 2014 19:00:27 GMT

Maybe something like....
Sum({<RECEIVED_DATE={''}, ASSUM_CONSUM-={''}>}DVALUE)

Re: Set Analysis and Nulls

Wed, 29 Jan 2014 19:26:03 GMT

Hey Steve,

Please check out the attached file. I created a table with three expressions one is just a sum, other sum except null and third is sum for only null.

Hope it helps you

Thanks

Re: Set Analysis and Nulls

Anonymous — Wed, 29 Jan 2014 19:34:26 GMT

Yes, you're on the right track.
File from Ajay Prabhakaran is a little better because it is explicit about 1 and $, but your version works too.

Re: Set Analysis and Nulls

stevegimbrollmt — Mon, 10 Feb 2014 11:13:31 GMT

Thanks to all with the feedback and all of your suggestions helped.. It turned out that the requirement slightly changed but these were still good guidelines.

Thanks again