topic Re: Bar chart and Pivot table count mismatches. in QlikView https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633644#M232419 <HTML><HEAD></HEAD><BODY><P>Uhu, Now I get it.</P><P>But Sort order has very big influence on the result, so my question is</P><P>what result is correct on your opinion Bar Chart or Pivot Table?</P><P></P><P>Andrei</P></BODY></HTML> Fri, 30 May 2014 10:11:15 GMT crusader_ 2014-05-30T10:11:15Z Bar chart and Pivot table count mismatches. https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633639#M232414 <HTML><HEAD></HEAD><BODY><P>Please go through the sample file attached. It contains the issue details i am having.</P><P></P><P></P><P>I am having two objects one Bar graph and other as pivot table. The counts ore mismatched in both.</P></BODY></HTML> Fri, 30 May 2014 08:38:37 GMT https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633639#M232414 2014-05-30T08:38:37Z Re: Bar chart and Pivot table count mismatches. https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633640#M232415 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You use different expressions in charts, which one should be correct?</P><P>In graph you just count(ID),&nbsp; in table </P><P>=RangeSum(Above(TOTAL Count(DISTINCT(ID)),0,RowNo(TOTAL)))</P><P></P><P>Andrei</P></BODY></HTML> Fri, 30 May 2014 09:04:23 GMT https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633640#M232415 crusader_ 2014-05-30T09:04:23Z Re: Bar chart and Pivot table count mismatches. https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633641#M232416 <HTML><HEAD></HEAD><BODY><P>Andrei ,</P><P>Try using your way in my sample.</P><P>I have tried and it did not work.</P><P></P><P>Is it some Qlikview limitation or just some more expression modification con achieve it.</P></BODY></HTML> Fri, 30 May 2014 09:22:13 GMT https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633641#M232416 2014-05-30T09:22:13Z Re: Re: Bar chart and Pivot table count mismatches. https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633642#M232417 <HTML><HEAD></HEAD><BODY><P>Hm.. smth wrong with your Chart in sample.</P><P>PFA.</P><P>HTH</P><P></P><P>Andrei</P></BODY></HTML> Fri, 30 May 2014 09:40:27 GMT https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633642#M232417 crusader_ 2014-05-30T09:40:27Z Re: Bar chart and Pivot table count mismatches. https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633643#M232418 <HTML><HEAD></HEAD><BODY><P>Adrei it is not as simple as you are thinking.</P><P>I am using cummalative sum in chart and table.</P><P>OK </P></BODY></HTML> Fri, 30 May 2014 09:57:58 GMT https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633643#M232418 2014-05-30T09:57:58Z Re: Bar chart and Pivot table count mismatches. https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633644#M232419 <HTML><HEAD></HEAD><BODY><P>Uhu, Now I get it.</P><P>But Sort order has very big influence on the result, so my question is</P><P>what result is correct on your opinion Bar Chart or Pivot Table?</P><P></P><P>Andrei</P></BODY></HTML> Fri, 30 May 2014 10:11:15 GMT https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633644#M232419 crusader_ 2014-05-30T10:11:15Z Re: Bar chart and Pivot table count mismatches. https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633645#M232420 <HTML><HEAD></HEAD><BODY><P>Pivot table is correct.</P></BODY></HTML> Fri, 30 May 2014 10:19:35 GMT https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633645#M232420 2014-05-30T10:19:35Z Re: Bar chart and Pivot table count mismatches. https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633646#M232421 <HTML><HEAD></HEAD><BODY><P>According to your data (Add simple table box to check) the Bar Chart work's correctly</P><P>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.</P><P>If Pivot table correct that you should use smth else (not Full accumulation)</P></BODY></HTML> Fri, 30 May 2014 10:25:58 GMT https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633646#M232421 crusader_ 2014-05-30T10:25:58Z Re: Bar chart and Pivot table count mismatches. https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633647#M232422 <HTML><HEAD></HEAD><BODY><P>Any one any idea for these </P></BODY></HTML> Fri, 30 May 2014 11:35:20 GMT https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633647#M232422 2014-05-30T11:35:20Z Re: Bar chart and Pivot table count mismatches. https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633648#M232423 <HTML><HEAD></HEAD><BODY><P>Look here: <A href="https://community.qlik.com/message/538811">Re: ANY EXPERT HAS THE SOLUTION !!</A></P></BODY></HTML> Fri, 30 May 2014 12:35:12 GMT https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633648#M232423 tresB 2014-05-30T12:35:12Z Re: Bar chart and Pivot table count mismatches. https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633649#M232424 <HTML><HEAD></HEAD><BODY><P>Really well it helped to make the things consistent in objects.</P></BODY></HTML> Fri, 30 May 2014 14:00:53 GMT https://community.qlik.com/t5/QlikView/Bar-chart-and-Pivot-table-count-mismatches/m-p/633649#M232424 2014-05-30T14:00:53Z