topic Re: Guarge chart in QlikView

Guarge chart

roee1983 — Thu, 19 Sep 2013 05:59:49 GMT

Hi All,

why do i see diffrent resualts when i make the same calculate once in straight table and secound in Guage chart?

when i export both of them to excel i get the same totals and average?

thanks

Roee

Re: Guarge chart

AbhijitBansode — Thu, 19 Sep 2013 06:04:09 GMT

Guage chart will display Experession result by neglecting any dimension.

Adding diemsnion rto guage chart will make no sense hence.

While Straight table will calculate expression using dimension.

but when you export them to excel totals will match.

Re: Guarge chart

Thu, 19 Sep 2013 06:44:24 GMT

Hi Roee,

Gauge chart will not consider dimension for any calculation whereas a straight table will do the calculation based on dimension.

From Qlikview Help :

"Gauge Chart are used to display the value of single expression lacking dimensions".

Hence you have the difference when viewing the calculation in chart, but when you export to excel totals become the same as there is bno difference of dimensions then.

Hope this helps!