Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Matrix Show all Values(x,y axes) but hide null

Dear Community,

i need to build a matrix with A and B axes.

All the time all possible values of A and B should be visible, so the matrix should be fully expanded.

For such a model i use a pivot with two dimensions A&B and an expression with simple 'x'.

The dimensions A and B have simple inline data 1,2,3,4,5 and i checked "show all values" for them.

Also there is data for A and B combinations but not for all possible combinations.

m1.png

=> The Problem is that also null values of A & B are displayed

If i check "Suppress When Value is Null" for the dimensions, i lose the benefit of "show all values"  as for these dimensions

combination where we dont have data, the dimension value is not displayed.

m2.png

so how can i make it pssible to have all possible dimensions without NULL inside the matrix

with data that is not for all combinations of A&B present.



Best regards!


11 Replies
Anonymous
Not applicable
Author

Wow Sunny so fast and good, that was it! Thanks so much!

sunny_talwar

Awesome, I am glad we were quickly able to figure it out