Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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!