topic Re: Removing Dimension from the context straight table in QlikView https://community.qlik.com/t5/QlikView/Removing-Dimension-from-the-context-straight-table/m-p/1274348#M400447 <HTML><HEAD></HEAD><BODY><P>How were you using it?</P></BODY></HTML> Fri, 24 Mar 2017 11:45:57 GMT sunny_talwar 2017-03-24T11:45:57Z Removing Dimension from the context straight table https://community.qlik.com/t5/QlikView/Removing-Dimension-from-the-context-straight-table/m-p/1274345#M400444 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>For example, i have sales in various countries in various years, I have a straight table with the country as a dimension. I have sum(Sales) as one expression. In second expression I need the sum of sales across all the countries besides my expression1.</P><P></P><P>Thanks in advance</P></BODY></HTML> Fri, 24 Mar 2017 11:33:35 GMT https://community.qlik.com/t5/QlikView/Removing-Dimension-from-the-context-straight-table/m-p/1274345#M400444 Anonymous 2017-03-24T11:33:35Z Re: Removing Dimension from the context straight table https://community.qlik.com/t5/QlikView/Removing-Dimension-from-the-context-straight-table/m-p/1274346#M400445 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Sum(TOTAL Sales) - Sum(Sales)</STRONG></P></BODY></HTML> Fri, 24 Mar 2017 11:35:01 GMT https://community.qlik.com/t5/QlikView/Removing-Dimension-from-the-context-straight-table/m-p/1274346#M400445 sunny_talwar 2017-03-24T11:35:01Z Re: Removing Dimension from the context straight table https://community.qlik.com/t5/QlikView/Removing-Dimension-from-the-context-straight-table/m-p/1274347#M400446 <HTML><HEAD></HEAD><BODY><P>Thank you sunny. I have been using the TOTAL in the wrong way. </P></BODY></HTML> Fri, 24 Mar 2017 11:37:53 GMT https://community.qlik.com/t5/QlikView/Removing-Dimension-from-the-context-straight-table/m-p/1274347#M400446 Anonymous 2017-03-24T11:37:53Z Re: Removing Dimension from the context straight table https://community.qlik.com/t5/QlikView/Removing-Dimension-from-the-context-straight-table/m-p/1274348#M400447 <HTML><HEAD></HEAD><BODY><P>How were you using it?</P></BODY></HTML> Fri, 24 Mar 2017 11:45:57 GMT https://community.qlik.com/t5/QlikView/Removing-Dimension-from-the-context-straight-table/m-p/1274348#M400447 sunny_talwar 2017-03-24T11:45:57Z