topic Re: Problem hiding minichart/guage on dimension total line in QlikView

Problem hiding minichart/gauge on dimension total line

phcaptjim — Tue, 30 Apr 2013 17:16:57 GMT

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.

Any ideas?

Thanks!

Re: Problem hiding minichart/guage on dimension total line

Gysbert_Wassenaar — Tue, 30 Apr 2013 17:46:36 GMT

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.

Re: Problem hiding minichart/guage on dimension total line

phcaptjim — Tue, 30 Apr 2013 22:29:53 GMT

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)