Display a gauge if data is available. Otherwise grey out and hide the needle?

[#1]

Hi,

I have a gauge on display in qlikview, who's expression, max, min, and segments are calculated on the fly.

However, if the data for the expression is unavailable I get "Bad Min or Max Value in Gauge" (thought actually the min and max values are always there, it's just the expression data that's not available), this data may not be available because there is no data for the selected date.

My question is, rather than display the "Bad Min or Max Value in Gauge" message, would it be possible to hide the gauge compleatly, or grey it out and hide the value needle.

It's a case of aesthetics really...

[manishkumar75]

Hi,

To hide the Gauge Completely, you can use Show -->(Conditional) option of Chart object under Layout tab. In the condition you can specify appropriate condition.

Hope , it will work.

- Manish

[#3]

So the condition would be

= if(value > 0,1)

Is that right? if the value is available then return 1 (true)?

[#4 · Accepted solution]

Hi,

Check the attached application, im sure that will help you.

- Sridhar

[#5]

Hi,

But what if I have the Gauge for one of my dimensions in the pivot table..

Any pointers.. I am facing the same issue..

Thanks

-Ashish