Please go through the sample file attached. It contains the issue details i am having.
I am having two objects one Bar graph and other as pivot table. The counts ore mismatched in both.
You use different expressions in charts, which one should be correct?
In graph you just count(ID), in table
Try using your way in my sample.
I have tried and it did not work.
Is it some Qlikview limitation or just some more expression modification con achieve it.
Uhu, Now I get it.
But Sort order has very big influence on the result, so my question is
what result is correct on your opinion Bar Chart or Pivot Table?
According to your data (Add simple table box to check) the Bar Chart work's correctly
Because you don't have any ID with type Sold in MARCH as soon as you don't have any ID with type "Not Sold" in Oct.
If Pivot table correct that you should use smth else (not Full accumulation)