topic pivot table issue in QlikView

pivot table issue

Wed, 23 Sep 2015 13:37:20 GMT

Hi Expert,

i have attached the sample qvw.

i have two tables in that as per my requirement.

but two tables showing different values on expression.

i have selected a particular product for example.

i need to total products going from location1 to location2 on one day and how many returned from location2 to location1 from next day.

but both tables should have same values.

Please help me on this.

qlikviewwizard — Wed, 23 Sep 2015 14:01:48 GMT

Hi,

Your requirement is not clear. Can you demonstrate it with an example?

Wed, 23 Sep 2015 14:07:09 GMT

Hi,

Please check the attached screenshots

both table has same selections but the expression value is different.

first table value is correct. but second table value is wrong for first expression.

how to change the expression so that second table shows same value as first table on the two expressions