Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
You use different expressions in charts, which one should be correct?
In graph you just count(ID), in table
=RangeSum(Above(TOTAL Count(DISTINCT(ID)),0,RowNo(TOTAL)))
Andrei
Andrei ,
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.
Hm.. smth wrong with your Chart in sample.
PFA.
HTH
Andrei
Adrei it is not as simple as you are thinking.
I am using cummalative sum in chart and table.
OK
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?
Andrei
Pivot table is correct.
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)
Any one any idea for these
Look here: Re: ANY EXPERT HAS THE SOLUTION !!