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

Suppress When Value Is Null breaks Expression with Total <Dimension>

I noticed that the option Suppress When Value Is Null apperently breaks Expression with Total <Dimension>.

Example data:

OBJECTLEVEL1LEVEL2KPIYEAR
AA302011
BAB152011
CAC152011
DD402011
EDE152011
FDF102011
GDG152011
AA422012
BAB162012
CAC262012
DD522012
EDE202012
FDF162012
GDG162012

When a single value of LEVEL1 is selected, I need to display all associated LEVEL2 values, combined with the YEAR and the KPI value (MAX, MIN, doesn't matter). So far, so simple.

Now I need a second expression column that shows the the associated KPI value of the LEVEL1 OBJECT in the respective YEAR. I can do that using a Set expression an the Total Qualifier: =MAX({1<OBJECT={"$(=ONLY(LEVEL1))"}>} TOTAL <YEAR> KPI)

Again, simple.

Trouble ahead: Currently, the rows with null-Values of the LEVEL2 are dispalyed, which is not wanted. I can suppress them via the option named in the title ("Suppress When Value Is Null"). However, then, the expression breaks. Why? Any Ideas?


See my uploaded workbook as an example.

Thanks!

1 Reply
swuehl
MVP
MVP

Maybe like attached

edit: see also

Re: Ignore one dimension in a pivot table