topic circular gauges behavior with null value in QlikView

circular gauges behavior with null value

Fri, 06 Nov 2009 22:03:00 GMT

I'm using some circular gauges in my QlikView reports.

My expression is a ration (A/B). Sometimes the result is null (if B=0). When it occurs, the gauge is replaced by an error message, it is possible to configure it (for example the gauge is drawn but no the arrow ?)

Best regards

circular gauges behavior with null value

prieper — Fri, 06 Nov 2009 22:14:06 GMT

Have you tried to prevent this error with an IF-clause, like

IF(B=0, 0, A/B)

Thus you should get a 'real' result and the graph will be shown, but with no content

HTH
Peter

circular gauges behavior with null value

Fri, 06 Nov 2009 22:19:10 GMT

I think about that solution before,

but unfortunately, 0 is not a real result on that case 🙂

circular gauges behavior with null value

prieper — Fri, 06 Nov 2009 22:56:43 GMT

But what are you looking for:
an empty gauge? -> described above
no gauge/no error? -> Properties - Layout - Show - Conditional (B<> 0)

HTH
Peter

circular gauges behavior with null value

Fri, 06 Nov 2009 23:59:51 GMT

I'm looking for an empty gauge?

but If I display 0, 0 is a value, so the arrow of the gauge is displayed and it is set to 0.

circular gauges behavior with null value

prieper — Sun, 08 Nov 2009 05:43:09 GMT

Am not working that much with Gauges, but in the below example, you have a gauge displayed without arrow, if dividing by 0 - and also no error-message.

Peter

Re: circular gauges behavior with null value

jcamps — Tue, 05 Nov 2013 12:05:57 GMT

A little late but... this is solved by setting "Text as popup" in the Expressions tab. QV will draw the gauge without an arrow instead of a "no data" message.