Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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"},....

View solution in original post

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!