Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
I think about that solution before,
but unfortunately, 0 is not a real result on that case 🙂
But what are you looking for:
an empty gauge? -> described above
no gauge/no error? -> Properties - Layout - Show - Conditional (B<> 0)
HTH
Peter
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.
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
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.