topic Re: wrong chart in QlikView https://community.qlik.com/t5/QlikView/wrong-chart/m-p/866256#M1015699 <HTML><HEAD></HEAD><BODY><P>Are you using the same expression in the pivot table?</P></BODY></HTML> Tue, 07 Apr 2015 17:51:42 GMT Anonymous 2015-04-07T17:51:42Z wrong chart https://community.qlik.com/t5/QlikView/wrong-chart/m-p/866254#M1015697 <HTML><HEAD></HEAD><BODY><P> Dear,</P><P><SPAN style="color: black; font-family: 'Arial','sans-serif'; font-size: 10pt;">I aspect to have the end of the&nbsp; trend of YTD 2014 series with Year=2014 and&nbsp; Order type =J;G around 800-1000 as showed in pivot table picture, instead it is 5000-6000 as in chart picture</SPAN></P><P></P><P> <SPAN style="color: black; font-family: 'Arial','sans-serif'; font-size: 10pt;">the expression to calculate it is <BR /><SPAN style="color: blue; font-family: 'Arial','sans-serif'; font-size: 10pt;">rangesum</SPAN><SPAN style="color: black; font-family: 'Arial','sans-serif'; font-size: 10pt;">(</SPAN><SPAN style="color: blue; font-family: 'Arial','sans-serif'; font-size: 10pt;">above</SPAN><SPAN style="color: black; font-family: 'Arial','sans-serif'; font-size: 10pt;">(</SPAN><SPAN style="color: blue; font-family: 'Arial','sans-serif'; font-size: 10pt;">Sum</SPAN><SPAN style="color: black; font-family: 'Arial','sans-serif'; font-size: 10pt;">({1&lt;</SPAN><SPAN style="color: maroon; font-family: 'Arial','sans-serif'; font-size: 10pt;">Year</SPAN><SPAN style="color: black; font-family: 'Arial','sans-serif'; font-size: 10pt;"> = {'2014'}, AlsisStatus = {'G','J'}&gt;}CountOrder), 0, Rowno()))</SPAN></SPAN></P><P></P><P> <SPAN style="color: black; font-family: 'Arial','sans-serif'; font-size: 10pt;">please what is wrong?</SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial;"><BR /><BR /><BR /></SPAN></P><P><SPAN style="font-size: 10pt; font-family: Arial;"><BR /><BR /></SPAN></P></BODY></HTML> Tue, 07 Apr 2015 13:04:36 GMT https://community.qlik.com/t5/QlikView/wrong-chart/m-p/866254#M1015697 2015-04-07T13:04:36Z Re: wrong chart https://community.qlik.com/t5/QlikView/wrong-chart/m-p/866255#M1015698 <HTML><HEAD></HEAD><BODY><P>I don't see what is wrong.</P><P></P><P>The other chart is showing a list of numbers that adds up to a number in the 5000-6000 range (after 50 weeks / 12 months), so it just seems correct.</P><P></P><P>Try to do this with less data and/or share that data.</P><P>Please also be a little bit more describing about what we are supposed to see / make up out of the screenshot. Thank you!</P></BODY></HTML> Tue, 07 Apr 2015 15:37:02 GMT https://community.qlik.com/t5/QlikView/wrong-chart/m-p/866255#M1015698 oknotsen 2015-04-07T15:37:02Z Re: wrong chart https://community.qlik.com/t5/QlikView/wrong-chart/m-p/866256#M1015699 <HTML><HEAD></HEAD><BODY><P>Are you using the same expression in the pivot table?</P></BODY></HTML> Tue, 07 Apr 2015 17:51:42 GMT https://community.qlik.com/t5/QlikView/wrong-chart/m-p/866256#M1015699 Anonymous 2015-04-07T17:51:42Z Re: wrong chart https://community.qlik.com/t5/QlikView/wrong-chart/m-p/866257#M1015700 <HTML><HEAD></HEAD><BODY><P>Your spellchecker doesn't recognize AlsisStatus (?)</P></BODY></HTML> Tue, 07 Apr 2015 18:07:23 GMT https://community.qlik.com/t5/QlikView/wrong-chart/m-p/866257#M1015700 Anonymous 2015-04-07T18:07:23Z Re: wrong chart https://community.qlik.com/t5/QlikView/wrong-chart/m-p/866258#M1015701 <HTML><HEAD></HEAD><BODY><P>Thank you very much for your kind reply</P></BODY></HTML> Wed, 08 Apr 2015 05:58:35 GMT https://community.qlik.com/t5/QlikView/wrong-chart/m-p/866258#M1015701 2015-04-08T05:58:35Z Re: wrong chart https://community.qlik.com/t5/QlikView/wrong-chart/m-p/866259#M1015702 <HTML><HEAD></HEAD><BODY><P>Thank you very much for your feedback, therefore I just started with Qlikview, sometime I don't see <SPAN class="hps">obvious.</SPAN></P></BODY></HTML> Wed, 08 Apr 2015 06:00:44 GMT https://community.qlik.com/t5/QlikView/wrong-chart/m-p/866259#M1015702 2015-04-08T06:00:44Z