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: 
qliksensedlin
Contributor II
Contributor II

Maintain Dimension Values

Hi,

I wonder if it is possible to maintain a fixed set of dimension values. For example, in a Bar chart, the x-axis label (dimension value) will be gone if the measures are calculated to 0. I also set the "Include null values" to be true for my dimension values, but it does not solve the problem.

1.PNG

2.PNG

Is there a way I can maintain the dimension values shown in the x-axis?

Thanks in advance.

1 Solution

Accepted Solutions
sunny_talwar

Add this to your expression and see if it helps

Your Expression + Sum({1} 0)

View solution in original post

2 Replies
sunny_talwar

Add this to your expression and see if it helps

Your Expression + Sum({1} 0)

qliksensedlin
Contributor II
Contributor II
Author

It works like a charm! Thanks a lot.