topic Re: Pivot table data getting wrongly from table in QlikView

Pivot table data getting wrongly from table

djaykumar — Sat, 16 Nov 2024 18:39:51 GMT

Hi All,

I am facing issue with pivot table. As I am getting wrong data in pivot table from source table

please find below screenshot

In the above screenshot dimension value is correct where as calculated value is getting wrongly for some rows.

Please help me in this as I am struck in deep.

Thanks,

Jay

lironbaram — Tue, 12 May 2020 06:27:48 GMT

it's seems you have several rows for the combination of dimension you use

you can see that where the numbers are "wrong" , you can always divide the expression by the net value dimension
and you'll get an integer ,

as rule of thumb charts don't get you the wrong numbers , it's related to your source table

you should either remove duplicate rows, or use another expression

djaykumar — Tue, 12 May 2020 11:01:07 GMT

Hi Lironbaram,

Thanks for Reply

As per you I have loaded again from source and I am getting correctly now.

Regards,

Jay