topic Multiple gauge chars based on targets in QlikView

Multiple gauge chars based on targets

Mon, 01 Nov 2010 12:58:54 GMT

Hello all,

I am struggeling with multiple gauge charts.

I (or in fact the customer) want to see 3 charts with different selections (fixed) based on a target.

If I make a qauge chart I do not know how to make a selection fixed. If I know that, I can copy the original and change the fixed selection.

This is option 1 (above) in my example. If you just choose 1 questname like 'Courtesy/helpfulness of staff during transfer' you will see that this option works. The line between red and green is the target and the needle is the score. Perfect...but I want 3 charts with this for 3 different questnames. I really like the layout of this chart.

Because this does not work, I also tried another way, option 2 in my example. I do not like the layout of this, but it is working for the 3 different questnames. The thing is....all targets shows the complete average instead of the average for each questname.

Can anyone help me with this? If you need more information, please ask me and I will try to explain.

Thank you in advance!

Multiple gauge chars based on targets

Mon, 01 Nov 2010 13:24:12 GMT

Hi Patricia,

use the SET Analysis in the expression of the "real" gauge chart:


Sum ({$ <Questname = {'Ease of transferring'}> } weighted)
/
Count ({$ <Questname = {'Ease of transferring'}> } score)
/
100

Then you can duplicate your gauge chart and apply the two others with the appriciate expression.

Regards, Roland

Multiple gauge chars based on targets

Mon, 01 Nov 2010 13:32:04 GMT

Hi again,

take a glance at your modified app.

Multiple gauge chars based on targets

Mon, 01 Nov 2010 14:03:08 GMT

Thanks Roland! You made my day! I am very happy with this result.

I saw this in another post, but it did not work in my application. I think I did something wrong. Now you sent me the code and it worked!

You can take a look at my updated file, I also did it for the targets! This is going to be a very nice dashboard!

Thanx again!