topic Re: Straight Table? in QlikView https://community.qlik.com/t5/QlikView/Straight-Table/m-p/96978#M600305 <HTML><HEAD></HEAD><BODY><P>Look here</P><P><A href="https://community.qlik.com/message/1566048">Re: Straight Table?</A></P></BODY></HTML> Wed, 31 Oct 2018 15:04:11 GMT sunny_talwar 2018-10-31T15:04:11Z Straight Table? https://community.qlik.com/t5/QlikView/Straight-Table/m-p/96977#M600304 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I have a requirement where i need to load the variables and show the difference between two variables in starlight table.</P><P></P><P>PFA, which has example data and explains the requirement.</P><P></P><P><STRONG>Data;</STRONG></P><P>load * inline [</P><P>Region, Sales, Year</P><P>NYC, 100, 2017</P><P>NYC, 200, 2018</P><P>NJ, 300, 2018</P><P>NJ, 400, 2017</P><P>CA, 500, 2018</P><P>CA, 600, 2017</P><P>SA, 700, 2018</P><P>SA, 800, 2017</P><P>FL, 900, 2018</P><P>FL, 250, 2017];</P><P></P><P><STRONG>Variables:</STRONG></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 529px;"><TBODY><TR><TD height="20" width="145">v_Sales2018</TD><TD width="384">=Sum({&lt;Year={2018}&gt;}Sales)</TD></TR><TR><TD height="20">v_Sales2017</TD><TD>=Sum({&lt;Year={2017}&gt;}Sales)</TD></TR><TR><TD height="20">v_NYC2018</TD><TD>=sum({&lt;Region={'NYC'},Year={'2018'}&gt;}Sales)</TD></TR><TR><TD height="20">v_NYC2017</TD><TD>=sum({&lt;Region={'NYC'},Year={'2017'}&gt;}Sales)</TD></TR><TR><TD height="20">v_NYCFL2018</TD><TD>=sum({&lt;Region={'NYC','FL'},Year={'2018'}&gt;}Sales)</TD></TR><TR><TD height="20">v_NYCFL2017</TD><TD>=sum({&lt;Region={'NYC','FL'},Year={'2017'}&gt;}Sales)</TD></TR></TBODY></TABLE><P></P><P><STRONG>Straight table should be like below:</STRONG></P><P></P><P>CoulmnA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ColumnB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ColumnC(difference between variables)</P><P>2600&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2150&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 450&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ....&nbsp;&nbsp; which is vSales2018-vSales2017</P><P>200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ....&nbsp;&nbsp; which is v_NYC2018-v_NYC2017</P><P>1100&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 350&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 750&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ....&nbsp;&nbsp; which is v_NYCFL2018-v_NYCFL2017</P><P></P><P></P><P>Can anyone please help me understand and give any possible solution.</P><P></P><P>Thanks</P></BODY></HTML> Wed, 31 Oct 2018 14:44:13 GMT https://community.qlik.com/t5/QlikView/Straight-Table/m-p/96977#M600304 qlikuser222 2018-10-31T14:44:13Z Re: Straight Table? https://community.qlik.com/t5/QlikView/Straight-Table/m-p/96978#M600305 <HTML><HEAD></HEAD><BODY><P>Look here</P><P><A href="https://community.qlik.com/message/1566048">Re: Straight Table?</A></P></BODY></HTML> Wed, 31 Oct 2018 15:04:11 GMT https://community.qlik.com/t5/QlikView/Straight-Table/m-p/96978#M600305 sunny_talwar 2018-10-31T15:04:11Z