topic Two Values in Two Charts in QlikView

Two Values in Two Charts

anuradhaa — Wed, 03 Oct 2012 13:42:50 GMT

I have created line chart and Gauge Chart

Use same expression,

But i have two different values for same data set.

But the demenssion is diffrent

Please tell me how to use dimenssions in Gauge Chart

In line chart i used date as demenssion,

But it doesn't work in Gauge

Thanks

Gysbert_Wassenaar — Wed, 03 Oct 2012 13:52:05 GMT

Can you explain it bit more? What should the result look like and what does it look like now?

anuradhaa — Wed, 03 Oct 2012 13:58:59 GMT

In The Line cHart i have used

Date as the demenssion and Averege sales in expression

In the Gauge i have used Avg sales in expression and sales in demenssion

I think that's why i get two different valuses,

example for 3rd OCT i have 2.5 in line chart and .6 in gauge chart

Please help me to solve this

MayilVahanan — Wed, 03 Oct 2012 14:13:45 GMT

Gauge charts are used to display the value of a single expression without dimensions. So you can't use dimension in gauge

Its used to show the percentage