Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
stevegimbrollmt
Contributor II

Set Analysis and Nulls

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

Tags (3)
5 Replies
Partner
Partner

Re: Set Analysis and Nulls

I think this document will help you.

NULL handling in QlikView

Not applicable

Re: Set Analysis and Nulls

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

Not applicable

Re: Set Analysis and Nulls

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

AJ

mov
Esteemed Contributor III

Re: Set Analysis and Nulls

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.

stevegimbrollmt
Contributor II

Re: Set Analysis and Nulls

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