topic Re: table and chart not showing same data in QlikView

table and chart not showing same data

Mon, 03 Aug 2015 15:19:28 GMT

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

Re: table and chart not showing same data

Mon, 03 Aug 2015 16:24:52 GMT

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.

Re: table and chart not showing same data

Mon, 03 Aug 2015 16:44:18 GMT

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

Re: table and chart not showing same data

Clever_Anjos — Mon, 03 Aug 2015 16:46:00 GMT

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

Re: table and chart not showing same data

Tue, 04 Aug 2015 07:32:52 GMT

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

Re: table and chart not showing same data

marcus_sommer — Tue, 04 Aug 2015 08:49:27 GMT

For anyone see: chart and table not showing same data

- Marcus

Re: table and chart not showing same data

zkn_0247 — Tue, 04 Aug 2015 09:18:42 GMT

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