topic Get cell value from a straight table in QlikView https://community.qlik.com/t5/QlikView/Get-cell-value-from-a-straight-table/m-p/284267#M1201145 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P>I dont know if there is any way to do this.</P><P>I have a <B>Straight Table</B> like this:</P><P></P><P>Example1:</P><P>HOTEL NIGHTS TOTAL_SPENT</P><P>NewYorker 4 400$</P><P>Fashion26 3 280$</P><P>Hotel123 2 <B>180$</B></P><P>......</P><P></P><P>Example2:</P><P>HOTEL NIGHTS TOTAL_SPENT</P><P>Hotel123 2 <B></B>180$</P><P>NewYorker 4 400$</P><P>Fashion26 3 <B>280$</B></P><P style="font-weight: bold"></P><P>......</P><P>This table is an <B>Straight Table</B> and have 1 Dimension ('HOTEL'), and you can order the information by NIGHT or TOTAL_SPENT.</P><P>What I want to get is the <B>3º value</B> of this table, placed in TOTAL_SPENT. I´d like to get allways the 3º value, doesn´t matter how you order the information.</P><P>In my Example1 the value I´d get will be '180$' and in the Example2 I´d get will be '280$'</P><P></P><P>Thanks a lot</P><P></P></BODY></HTML> Wed, 27 Oct 2010 10:01:53 GMT 2010-10-27T10:01:53Z Get cell value from a straight table https://community.qlik.com/t5/QlikView/Get-cell-value-from-a-straight-table/m-p/284267#M1201145 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P>I dont know if there is any way to do this.</P><P>I have a <B>Straight Table</B> like this:</P><P></P><P>Example1:</P><P>HOTEL NIGHTS TOTAL_SPENT</P><P>NewYorker 4 400$</P><P>Fashion26 3 280$</P><P>Hotel123 2 <B>180$</B></P><P>......</P><P></P><P>Example2:</P><P>HOTEL NIGHTS TOTAL_SPENT</P><P>Hotel123 2 <B></B>180$</P><P>NewYorker 4 400$</P><P>Fashion26 3 <B>280$</B></P><P style="font-weight: bold"></P><P>......</P><P>This table is an <B>Straight Table</B> and have 1 Dimension ('HOTEL'), and you can order the information by NIGHT or TOTAL_SPENT.</P><P>What I want to get is the <B>3º value</B> of this table, placed in TOTAL_SPENT. I´d like to get allways the 3º value, doesn´t matter how you order the information.</P><P>In my Example1 the value I´d get will be '180$' and in the Example2 I´d get will be '280$'</P><P></P><P>Thanks a lot</P><P></P></BODY></HTML> Wed, 27 Oct 2010 10:01:53 GMT https://community.qlik.com/t5/QlikView/Get-cell-value-from-a-straight-table/m-p/284267#M1201145 2010-10-27T10:01:53Z