topic Re: straight table- expression written for a rowno in QlikView https://community.qlik.com/t5/QlikView/straight-table-expression-written-for-a-rowno/m-p/376162#M140200 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please can you little more clear on your question or attach sample app of your task.</P><P></P><P>Regards,</P><P>Venkat</P></BODY></HTML> Wed, 08 Aug 2012 12:44:29 GMT 2012-08-08T12:44:29Z straight table- expression written for a rowno https://community.qlik.com/t5/QlikView/straight-table-expression-written-for-a-rowno/m-p/376161#M140199 <HTML><HEAD></HEAD><BODY><P>i have a straight table in which I have made 'horizontal' under presentation tab. so for eg </P><P>1. quarter is my dimension</P><P>2. sales and rebate in my expressions</P><P>I get months in columns and other metrics in first column as shown in table.</P><P>I want a last column which gives (quarter3-quarter2) value. for this i used rowno concept and wrote in condition two expressions.</P><P></P><P></P><P>I am not getting values in last column. strange thing is for some metrics im getting n for some i dont.</P><P></P><P>Please help with this. Thanks</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="border: 1px solid #000000;"><TBODY><TR><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Quarter1</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Quarter2</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Quarter 3</STRONG></SPAN></TH></TR><TR><TD style="border: 1px solid #000000;">Netsales</TD><TD style="border: 1px solid #000000;">3445</TD><TD style="border: 1px solid #000000;">5678</TD><TD style="border: 1px solid #000000;">234</TD></TR><TR><TD style="border: 1px solid #000000;">Rebate</TD><TD style="border: 1px solid #000000;">33</TD><TD style="border: 1px solid #000000;">76</TD><TD style="border: 1px solid #000000;">56</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 08 Aug 2012 12:25:21 GMT https://community.qlik.com/t5/QlikView/straight-table-expression-written-for-a-rowno/m-p/376161#M140199 2012-08-08T12:25:21Z Re: straight table- expression written for a rowno https://community.qlik.com/t5/QlikView/straight-table-expression-written-for-a-rowno/m-p/376162#M140200 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please can you little more clear on your question or attach sample app of your task.</P><P></P><P>Regards,</P><P>Venkat</P></BODY></HTML> Wed, 08 Aug 2012 12:44:29 GMT https://community.qlik.com/t5/QlikView/straight-table-expression-written-for-a-rowno/m-p/376162#M140200 2012-08-08T12:44:29Z Re: straight table- expression written for a rowno https://community.qlik.com/t5/QlikView/straight-table-expression-written-for-a-rowno/m-p/376163#M140201 <HTML><HEAD></HEAD><BODY><P>This is my straight table which i have made horizontal.</P><P>I want the subtract of 3rd and 1st column in the last column. for this i tried with rowno concept but its not working</P></BODY></HTML> Wed, 08 Aug 2012 12:46:43 GMT https://community.qlik.com/t5/QlikView/straight-table-expression-written-for-a-rowno/m-p/376163#M140201 2012-08-08T12:46:43Z