topic Re: RangeSum at 2 Dimensions Chart in QlikView https://community.qlik.com/t5/QlikView/RangeSum-at-2-Dimensions-Chart/m-p/1032308#M930152 <HTML><HEAD></HEAD><BODY><P>They are different because the order of the dimensions is different. The first groups the years per month, the other the months per year.</P></BODY></HTML> Mon, 21 Mar 2016 08:12:17 GMT Gysbert_Wassenaar 2016-03-21T08:12:17Z RangeSum at 2 Dimensions Chart https://community.qlik.com/t5/QlikView/RangeSum-at-2-Dimensions-Chart/m-p/1032306#M930150 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I had problem creating bar chart.</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">The "Chart-A" with setting:</SPAN></P><UL><LI><SPAN style="font-size: 10pt; line-height: 1.5em;">Dimensions: YEAR, MONTH</SPAN></LI><LI><SPAN style="font-size: 10pt; line-height: 1.5em;">Expressions: <STRONG style="color: #ff0000; font-size: 13.3333px;"><EM>=RangeSum(ABOVE(SUM(YIELD),0,RowNo())) / MONTH * 12</EM></STRONG> <BR /></SPAN></LI></UL><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">The "Chart-B" with setting:</SPAN></P><UL><LI><SPAN style="font-size: 10pt; line-height: 1.5em;">Dimensions: MONTH, YEAR</SPAN></LI><LI><SPAN style="font-size: 10pt; line-height: 1.5em;">Expressions: <STRONG style="color: #ff0000; font-size: 13.3333px;"><EM>=RangeSum(ABOVE(SUM(YIELD),0,RowNo())) / MONTH * 12</EM></STRONG> </SPAN></LI></UL><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt; line-height: 1.5em;">Why the both showing different chart and figure as the table data are the same.</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt; line-height: 1.5em;">Can anyone help.</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt; line-height: 1.5em;">Thanks<BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/RangeSum-at-2-Dimensions-Chart/m-p/1032306#M930150 2020-11-25T16:16:04Z Re: RangeSum at 2 Dimensions Chart https://community.qlik.com/t5/QlikView/RangeSum-at-2-Dimensions-Chart/m-p/1032307#M930151 <HTML><HEAD></HEAD><BODY><P>chk dis</P><P><A href="https://community.qlik.com/docs/DOC-8242">Missing Manual - Above() and Below()</A></P></BODY></HTML> Mon, 21 Mar 2016 07:46:31 GMT https://community.qlik.com/t5/QlikView/RangeSum-at-2-Dimensions-Chart/m-p/1032307#M930151 Chanty4u 2016-03-21T07:46:31Z Re: RangeSum at 2 Dimensions Chart https://community.qlik.com/t5/QlikView/RangeSum-at-2-Dimensions-Chart/m-p/1032308#M930152 <HTML><HEAD></HEAD><BODY><P>They are different because the order of the dimensions is different. The first groups the years per month, the other the months per year.</P></BODY></HTML> Mon, 21 Mar 2016 08:12:17 GMT https://community.qlik.com/t5/QlikView/RangeSum-at-2-Dimensions-Chart/m-p/1032308#M930152 Gysbert_Wassenaar 2016-03-21T08:12:17Z