topic Populate text in gauge chart in QlikView

Populate text in gauge chart

Fri, 01 Nov 2013 15:07:24 GMT

Is there a way to populate text beside the gauge chart indicator which will automatically shows ‘Conservative’ (0-25%), ‘Neutral’ (25-50%), ‘Aggressive’ (50-75%), ‘Excessive’ (75-100%)? Following snapshot is an example.

Thanks!

Re: Populate text in gauge chart

Nicole-Smith — Fri, 01 Nov 2013 15:22:11 GMT

Text in chart would be what you'd want. You can use CTRL+SHIFT to move things around.

Re: Populate text in gauge chart

stevedark — Fri, 01 Nov 2013 15:27:48 GMT

Hi Heok,

Nicole is on the money with how to place labels in the chart and move them about (Ctrl+Shift is not at all obvious!). What you will not be able to do is have the text track when the pointer is currently at - you would have to place the text at the appropriate place on the side.

If you wanted only to show the label that describes where the needle is pointing you need to put an expression in the text in chart, it will look a bit like this:

=if( [... your expression ...] <= 0.25, 'Conservative', '')

and

=if( [... your expression ...] > 0.25 and [... your expression ...] <= 0.5, 'Neutral', '')

As you will be repeating your expression a lot I would strongly recommend you move the code for it into a variable.

Hope that helps,

Steve

Re: Populate text in gauge chart

Fri, 01 Nov 2013 16:34:08 GMT

Thanks for your help!

Re: Populate text in gauge chart

Fri, 01 Nov 2013 16:34:24 GMT

Thanks for your help!