Meter graph based on target

[#1]

Hello all,

My customer really wants meters as a kind of dashboard on the first page. I have weighted averages in the applications and targets and show a red color if the weighted average is lower than the target.

But they really like meters. I tried to make them, but I can only put the weighted average in the meter graph. The minimum is 0 and maximum is 10. In between is 5 and that is the line for green/red. Standard qlikview will show from 0 till 5 a red color and from 5 till 10 a green color.

In my application we have a target for each question (it is a questionnaire application). So if the customer selects for example 'overall impression' the target is 6.7. Is it possible to set the meter on 6.7 for this question (so based on target) instead of the standard way? Because if the users selects for example 'food and beverages' the target is 6.3.

So basically I want the metres based on the target to see if the weighted averages is above or below. Is this possible?

Thank you in advance for your answer!

Best regards,

Patricia

[#2 · Accepted solution]

You can set expressions instead of values in the Presentation tab of the Chart Properties window.

If you set up a relation between question type and target (i.e. create a table with a target for each question type) or load a target value for each question, you can use a calculated expression in the "Lower Bound" cell.

Something like "=target".

Bye!

[#3]

Perfect, it works! I already tried these things before, but the line red/green stays in the middle. Now I showed the values and I see it is based on target now.

Thank you for your reply!

An extra question if you do not mind: Do you also know how to show the value of the metre (and not pop-up)?

[#4]

AFAIK, the easier way is this:

1 - Go to Presentation tab and select "Add" in the "Text in Chart" section.

2 - Add a text with the value:

='Target: $(=Num(Only(target), '0.0')'

3 - Press ok -> ok.

This should give you a label with "Target: 6.0" (or whatever your target is).

4 - While having your Chart selected, press Shift+Ctrl and keep them pressed. This should give you red highlights of the various parts of the chart. Drag and resize you new label where you want.

5 - Have fun!

Bye

[#5]

Whoops, there is a typo. The formula should read as:

='Target: $(=Num(Only(target), '0.0'))'

With 2 parenthesys before the last quote.

Bye

[#6]

Hi!

Step 5 succeeded! and also step 1,2 and 3.

But drag en drop the text to another place in a metres graph is not possible I think.

I copied the metres graph and made a bar graph of the copy and it is easy to replace the text.

In the bar graph the mouse pointer will change to a + but not in the metres graph, so I think it is not possible.

[#7]

Strange, I succesfully moved text in Gauge chart.

In fact, the gauge chart is the only kind of chart I insert text into...

[#8]

Indeed, very strange.

Well, you solved my biggest problem. Maybe there is something wrong with my installation.

I will try some other things.

Thank you for your help!