Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Bar chart and Pivot table count mismatches.

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.

10 Replies
Partner
Partner

Re: Bar chart and Pivot table count mismatches.

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

Not applicable

Re: Bar chart and Pivot table count mismatches.

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.

Partner
Partner

Re: Re: Bar chart and Pivot table count mismatches.

Hm.. smth wrong with your Chart in sample.

PFA.

HTH

Andrei

Not applicable

Re: Bar chart and Pivot table count mismatches.

Adrei it is not as simple as you are thinking.

I am using cummalative sum in chart and table.

OK

Partner
Partner

Re: Bar chart and Pivot table count mismatches.

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

Not applicable

Re: Bar chart and Pivot table count mismatches.

Pivot table is correct.

Partner
Partner

Re: Bar chart and Pivot table count mismatches.

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)

Not applicable

Re: Bar chart and Pivot table count mismatches.

Any one any idea for these

MVP
MVP

Re: Bar chart and Pivot table count mismatches.