topic Re: Value doesn't match in QlikView

Value doesn't match

prma7799 — Fri, 13 Feb 2015 13:37:38 GMT

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

Thanks

Prashant

Re: Value doesn't match

alexandros17 — Fri, 13 Feb 2015 13:40:19 GMT

Could you share your doc?

Re: Value doesn't match

maternmi — Fri, 13 Feb 2015 13:41:35 GMT

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.

Michael

Re: Value doesn't match

alexandros17 — Fri, 13 Feb 2015 13:44:13 GMT

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

Re: Value doesn't match

Anonymous — Fri, 13 Feb 2015 13:44:16 GMT

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

Re: Value doesn't match

prma7799 — Fri, 13 Feb 2015 13:45:02 GMT

Hi,

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

Thanks

Re: Value doesn't match

robert_mika — Fri, 13 Feb 2015 13:45:34 GMT

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

Re: Value doesn't match

maternmi — Fri, 13 Feb 2015 14:04:14 GMT

Can somebody open the file? I can not.

Re: Value doesn't match

Fri, 13 Feb 2015 14:48:10 GMT

I am unable to open file.

Re: Value doesn't match

prma7799 — Fri, 13 Feb 2015 15:50:36 GMT

any idea?

Re: Value doesn't match

robert_mika — Fri, 13 Feb 2015 18:37:34 GMT

I'm working on personal edtion so can not open the file but if you can post your data,espression & dimension I can have a look

Re: Value doesn't match

sunny_talwar — Fri, 13 Feb 2015 20:43:53 GMT

What is the expression you are using to calculate Total TP/Unit in your pivot table? If it is any other then Sum, then you will need to use an aggregate function like this:

=Sum(Aggr(yourExpression, [Pack Year], [Supplier Name]))

Note: The above expression is assuming that you only have Pack Year and Supplier name as your dimension in the pivot table.

HTH

Best,

Re: Value doesn't match

Fri, 13 Feb 2015 21:58:48 GMT

Hi,

In your expression tab of pivot table, Click on Sum of rows in Total Mode.

Regards

Nandkishor S. Pandirkar

Re: Value doesn't match

prma7799 — Sat, 14 Feb 2015 04:48:32 GMT

Hi All,

I don't want to change any expression in Bar chart I want same output as like Pivot Table.

Thanks
Prashant

Re: Value doesn't match

robert_mika — Sat, 14 Feb 2015 05:45:56 GMT

Post your data/dimension/expression....

Re: Value doesn't match

prma7799 — Sat, 14 Feb 2015 05:55:37 GMT

Unable to send the data

PFA for dimension/expression

Re: Value doesn't match

robert_mika — Sat, 14 Feb 2015 06:07:26 GMT

prashantbi wrote:

Unable to send the data

You can not attached or are the confidential?

If is the first case :

Go t:

An and then:

Re: Value doesn't match

prma7799 — Mon, 16 Feb 2015 04:56:29 GMT

Hi .

PFA for Pivot table description.

Thanks

Prashant

Re: Value doesn't match

jagan — Mon, 16 Feb 2015 07:20:18 GMT

Hi,

Pivot table total will be based on the expression, so it is difficult to show that in Bar Chart and also it is not a correct value, if you sum the value in pivot table the total is not correct.

To fix the Total in Pivot table you can use you should use aggr()

Sum(Aggr(yourExpression, [Pack Year], [Supplier Name]))

Hope this helps you.

Regards,

Jagan.