topic rangesum with multiple dimensions in QlikView https://community.qlik.com/t5/QlikView/rangesum-with-multiple-dimensions/m-p/123523#M18825 <HTML><HEAD></HEAD><BODY><P>I have a pivot table with three dimensions:</P><P>1. Calculated dimension (calcdim)</P><P>2. Week</P><P>3. Year</P><P></P><P>The year-dimension values are columns</P><P></P><P>I want a running total over calcdim and week</P><P></P><P>I use this expression :</P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff;">rangesum</SPAN>(<SPAN style="color: #0000ff;">above</SPAN>( <SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #0000ff;">distinct</SPAN> employees)&nbsp; ,0, <SPAN style="color: #0000ff;">rowno</SPAN>() <SPAN style="color: #008000;"> </SPAN></SPAN><SPAN style="font-size: 10pt;">))</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">When calcdim is collapsed running total is&nbsp; calculated correct but when expanded , every calcdim it starts from zero.</SPAN></P><P><SPAN style="font-size: 10pt;">Is it possible to keep the cumulative total running ? </SPAN></P></BODY></HTML> Fri, 09 Nov 2018 14:29:32 GMT curiousfellow 2018-11-09T14:29:32Z rangesum with multiple dimensions https://community.qlik.com/t5/QlikView/rangesum-with-multiple-dimensions/m-p/123523#M18825 <HTML><HEAD></HEAD><BODY><P>I have a pivot table with three dimensions:</P><P>1. Calculated dimension (calcdim)</P><P>2. Week</P><P>3. Year</P><P></P><P>The year-dimension values are columns</P><P></P><P>I want a running total over calcdim and week</P><P></P><P>I use this expression :</P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff;">rangesum</SPAN>(<SPAN style="color: #0000ff;">above</SPAN>( <SPAN style="color: #0000ff;">count</SPAN>(<SPAN style="color: #0000ff;">distinct</SPAN> employees)&nbsp; ,0, <SPAN style="color: #0000ff;">rowno</SPAN>() <SPAN style="color: #008000;"> </SPAN></SPAN><SPAN style="font-size: 10pt;">))</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">When calcdim is collapsed running total is&nbsp; calculated correct but when expanded , every calcdim it starts from zero.</SPAN></P><P><SPAN style="font-size: 10pt;">Is it possible to keep the cumulative total running ? </SPAN></P></BODY></HTML> Fri, 09 Nov 2018 14:29:32 GMT https://community.qlik.com/t5/QlikView/rangesum-with-multiple-dimensions/m-p/123523#M18825 curiousfellow 2018-11-09T14:29:32Z Re: rangesum with multiple dimensions https://community.qlik.com/t5/QlikView/rangesum-with-multiple-dimensions/m-p/123524#M18826 <HTML><HEAD></HEAD><BODY><P>May be look here <A href="https://community.qlik.com/docs/DOC-7969">How to use - Dimensionality()</A></P></BODY></HTML> Fri, 09 Nov 2018 15:25:56 GMT https://community.qlik.com/t5/QlikView/rangesum-with-multiple-dimensions/m-p/123524#M18826 Anil_Babu_Samineni 2018-11-09T15:25:56Z Re: rangesum with multiple dimensions https://community.qlik.com/t5/QlikView/rangesum-with-multiple-dimensions/m-p/1505712#M436289 <P>&nbsp;</P><P><SPAN>Use the below expression and check if it helps , Use of Total can help you with that&nbsp;</SPAN></P><P><SPAN>=</SPAN><SPAN>rangesum(above( Total count(distinct&nbsp;employees)&nbsp; ,0,&nbsp;rowno(Total)&nbsp;</SPAN><SPAN>))</SPAN></P><P>&nbsp;</P> Wed, 14 Nov 2018 06:15:00 GMT https://community.qlik.com/t5/QlikView/rangesum-with-multiple-dimensions/m-p/1505712#M436289 swapniltaz 2018-11-14T06:15:00Z