Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

circular gauges behavior with null value

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

6 Replies
prieper
Master II
Master II

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

Not applicable
Author

I think about that solution before,

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

prieper
Master II
Master II

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

HTH
Peter

Not applicable
Author

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.

prieper
Master II
Master II

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

jcamps
Partner - Creator
Partner - Creator

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.