topic Divide two columns w/ 'Sum of Rows' in QlikView https://community.qlik.com/t5/QlikView/Divide-two-columns-w-Sum-of-Rows/m-p/1423403#M429073 <HTML><HEAD></HEAD><BODY><P>I have two columns with the total represented as the 'Sum of Rows'</P><P></P><P>I'm trying to get the % change by using this expression: Column(4) / Column(3) - 1, but it's using the expression totals rather than the totals shown in the table. </P><P></P><P>How do I get QlikView to use the row totals in the table rather than the expression totals?</P><P></P><P>Thanks!</P><P></P><P><IMG alt="ex.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/187403_ex.jpg" style="height: auto;" /></P></BODY></HTML> Mon, 18 Dec 2017 18:22:18 GMT jdmarlin 2017-12-18T18:22:18Z Divide two columns w/ 'Sum of Rows' https://community.qlik.com/t5/QlikView/Divide-two-columns-w-Sum-of-Rows/m-p/1423403#M429073 <HTML><HEAD></HEAD><BODY><P>I have two columns with the total represented as the 'Sum of Rows'</P><P></P><P>I'm trying to get the % change by using this expression: Column(4) / Column(3) - 1, but it's using the expression totals rather than the totals shown in the table. </P><P></P><P>How do I get QlikView to use the row totals in the table rather than the expression totals?</P><P></P><P>Thanks!</P><P></P><P><IMG alt="ex.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/187403_ex.jpg" style="height: auto;" /></P></BODY></HTML> Mon, 18 Dec 2017 18:22:18 GMT https://community.qlik.com/t5/QlikView/Divide-two-columns-w-Sum-of-Rows/m-p/1423403#M429073 jdmarlin 2017-12-18T18:22:18Z Re: Divide two columns w/ 'Sum of Rows' https://community.qlik.com/t5/QlikView/Divide-two-columns-w-Sum-of-Rows/m-p/1423404#M429074 <HTML><HEAD></HEAD><BODY><P>That depends on the expressions your table uses. But you won't be able to use the Column function.</P><P>What are the dimensions and what are the measures?</P></BODY></HTML> Mon, 18 Dec 2017 18:28:00 GMT https://community.qlik.com/t5/QlikView/Divide-two-columns-w-Sum-of-Rows/m-p/1423404#M429074 Gysbert_Wassenaar 2017-12-18T18:28:00Z