Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stevegimbrollmt
Creator II
Creator 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

5 Replies
Carlos_Reyes
Partner - Specialist
Partner - Specialist

I think this document will help you.

NULL handling in QlikView

Not applicable

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

Not applicable

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

Anonymous
Not applicable

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
Creator II
Creator II
Author

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