Bar chart and Pivot table count mismatches.

[#1]

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.

[crusader_]

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

[#3]

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.

[crusader_]

Hm.. smth wrong with your Chart in sample.

PFA.

HTH

Andrei

[#5]

Adrei it is not as simple as you are thinking.

I am using cummalative sum in chart and table.

OK

[crusader_]

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

[#7]

Pivot table is correct.

[crusader_]

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)

[#9]

Any one any idea for these

[tresesco]

Look here: Re: ANY EXPERT HAS THE SOLUTION !!