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: 
Not applicable

Set Analysis syntax for excluding nulls

Hi,

I got a pivot that sums total spend amount for various FY and I would like to exclude nulls from Sub Rollup without adding this field as dimension. Is this the correct syntax?

1 Solution

Accepted Solutions
sunny_talwar

I think, I might have made a mistake with the 1st two... try these

{<DRVD_PRD_SUB_ROLLUP = {'*'},....


or


{<DRVD_PRD_SUB_ROLLUP -= {"=Len(Trim(DRVD_PRD_SUB_ROLLUP )) > 0"},....

View solution in original post

8 Replies
sunny_talwar

Is it true null or does it says NULL? For true null, try one of these:

{<DRVD_PRD_SUB_ROLLUP -= {'*'},....

or

{<DRVD_PRD_SUB_ROLLUP = e({<DRVD_PRD_SUB_ROLLUP = {'*'}>}),....


or


{<DRVD_PRD_SUB_ROLLUP -= {"=Len(Trim(DRVD_PRD_SUB_ROLLUP )) > 0"},....

Not applicable
Author

Thanks Sunny! I'll try all three. Btw, what is the "e" for in this example?

{<DRVD_PRD_SUB_ROLLUP = e({<DRVD_PRD_SUB_ROLLUP = {'*'}>}),....

sunny_talwar

I think, I might have made a mistake with the 1st two... try these

{<DRVD_PRD_SUB_ROLLUP = {'*'},....


or


{<DRVD_PRD_SUB_ROLLUP -= {"=Len(Trim(DRVD_PRD_SUB_ROLLUP )) > 0"},....

sunny_talwar

e means exclude and p mean possible. Look at the attached document for more details on e and p

Not applicable
Author

So these two will exclude true null DRVD_PRD_SUB_ROLLUP ?

Not applicable
Author

<DRVD_PRD_SUB_ROLLUP = {'*'},.... worked but the others did not.

sunny_talwar

I left the - negative sign by mistake... should have been this

{<DRVD_PRD_SUB_ROLLUP = {"=Len(Trim(DRVD_PRD_SUB_ROLLUP )) > 0"},....

Not applicable
Author

Oh ok. Thanks!