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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
phcaptjim
Creator
Creator

Problem hiding minichart/gauge on dimension total line

I'm having a problem 'hiding' the gauge and mini chart value on the total line.  If you look at the example below, the first total line is fine, and the second one is having the issue.  The green gauge is showing up and a small 'dot' is showing up due to the mini chart.  The problem appears to happen on every other line, which is really odd.  As you can see line 1 and 3 (total lines) are working correctly.

This is a straight table.  It has two dimensions, the groupers and the measure name. 

qvw_problem.jpg

Any ideas?

Thanks!

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Have you tried using the dimensionality() function? You can try putting your original expression in an if statement using dimensionality in a condition. Something like if(dimensionality()=2, ...myexpressionhere...). You can first add dimensionality() as expression to see which level gets what value. Looking at your screenshot I guess the detail rows will have a dimensionality of 2, but I might be wrong.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Have you tried using the dimensionality() function? You can try putting your original expression in an if statement using dimensionality in a condition. Something like if(dimensionality()=2, ...myexpressionhere...). You can first add dimensionality() as expression to see which level gets what value. Looking at your screenshot I guess the detail rows will have a dimensionality of 2, but I might be wrong.


talk is cheap, supply exceeds demand
phcaptjim
Creator
Creator
Author

Problem solved!  This is exactly the function I was looking for.  Thanks!

This is what I added to my code:

=If(Dimensionality()=1,Null(),MyExpression)