pivot table issue

[#1]

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]

Hi,

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

[#3]

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