Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

table and chart not showing same data

Hi,

  I created one table and one chart for sum. but table is showing correct figures but chart's sum is not showing same as table sum. for table sum, I took export to excel and made sum. both are not same.

Reason ?

Thanks

Amit

1 Solution

Accepted Solutions
zkn_0247
Contributor II
Contributor II

There is duplication on some rows. you will have to check your origional data source and its record fetching query to remove duplication.

View solution in original post

6 Replies
Not applicable
Author

can you please provide an example? Having an application, even if it is a dummy application duplicating the issue would be a great help.

Are there negative numbers in the data?  What type of chart?  Is the table a straight, pivot or table box.

Not applicable
Author

Create pivot table and in exp write same exp what u used it will show same value

Clever_Anjos
Employee
Employee

Would you mind sharing some data, screenshots or your application?

Not applicable
Author

Hi,   
I am calculating epmplannedcost and in table, Its is showing correct figure when I do export to excel and sum. But when I used sum(epmplannedcost) in pivot chart, It is not showing correct data as table.

Thanks

marcus_sommer

For anyone see: chart and table not showing same data

- Marcus

zkn_0247
Contributor II
Contributor II

There is duplication on some rows. you will have to check your origional data source and its record fetching query to remove duplication.