Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master III
Master III

Value doesn't match

Hi All,

I have one bar chart and pivot table in that i have used same dimension and expression but why value has changed.

PFA for the same

Pivot.png

Bar.png

Thanks

Prashant

18 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Could you share your doc?

maternmi
Creator II
Creator II

Hi,

I suppose it has something to do with the fields you show in your Pivot-table. Copy the table and try to delete one by one until (so I hope) it shows the same value as in the bar Chart.

BR

Michael

alexandros17
Partner - Champion III
Partner - Champion III

Tranform your pivot i a bar chart ... check the result

Anonymous
Not applicable

if you look at the table and the row Grand total, the value is not correct.

if you add the previous rows you will get the value of the Chart.

if you Change the Expression from total to sum of rows you will get the same values

something does not match. look also at column commm no and the sum

prma7799
Master III
Master III
Author

Hi,

I copied and delete one by one as you say but no result matched.

Thanks

PM

robert_mika
Master III
Master III

Definitely your  Grand Totals sum in PivotTable does not match the field records totals.

maternmi
Creator II
Creator II

Can somebody open the file? I can not.

Not applicable

I am unable to open file.

prma7799
Master III
Master III
Author

any idea?