Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
roee1983
Contributor III
Contributor III

Guarge chart

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

2 Replies
AbhijitBansode
Specialist
Specialist

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.

Not applicable

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!