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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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