Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
mike_55
Contributor
Contributor

PLEASE HELP! Sum Function in creating Pivot Table is returning incorrect results!

For my dimension "RAKTAY" when I sum up SALES_FEE values in the pivot table chart the sum is returned incorrect. Please help me, I lost 4-5 hours trying to fix this. 

 

Capture4.JPG

Capture.JPGCapture2.JPGCapture3.JPG

Labels (2)
1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

yes 

in the app , access the data load editor 

in the main tab of the load script 

you have all the variables to set formatting of date and numbers 

in the first one , replace the thousand separator to what you need .

Annotation 2020-04-07 082153.png

View solution in original post

5 Replies
lironbaram
Partner - Master III
Partner - Master III

if 

you select RAKTAY in the model , and put the sum(SALES_FEE) expression in a kpi , does the result is true 

 

mike_55
Contributor
Contributor
Author

Hello Lironbaram! Thank you for quick reply. No kpi does not give correct answer either. If you look at my screenshot you can see that excel is giving the correct results but qlik does not. Capture6.JPG

mike_55
Contributor
Contributor
Author

Lironbaram I am thinking maybe this error is due to Qlik sense converting my number into a different format automatically. I noticed that $2,000 is converted into Qlik as $2.000 (with a dot instead of comma). Do you maybe know how to change automatic formating in qlik sense?

lironbaram
Partner - Master III
Partner - Master III

yes 

in the app , access the data load editor 

in the main tab of the load script 

you have all the variables to set formatting of date and numbers 

in the first one , replace the thousand separator to what you need .

Annotation 2020-04-07 082153.png

mike_55
Contributor
Contributor
Author

THANK YOU. FINALLY FIXED IT! HAVE A WONDERFUL DAY!