topic Row specific selections in QlikView https://community.qlik.com/t5/QlikView/Row-specific-selections/m-p/513486#M191882 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>I am trying to get the bottom most record and then go up five rows and perform an expression calculation.</P><P>For the fourth row from the bottom, I have another calculation and so forth.</P><P>The challenge I found using bottom is that if I say bottom(column xxx, 5) is that it takes the value in the bottom most row in column xxx and replicates it over each row of the bottom five rows.</P><P></P><P>I tried searching for an alternate function but could not find an equivalent. I cannot use rowno() as the number of rows can vary each time.</P><P></P><P>Would appreciate any assistance.</P><P></P><P>Thank you.</P><P><BR /> </P></BODY></HTML> Wed, 23 Oct 2013 14:41:02 GMT 2013-10-23T14:41:02Z Row specific selections https://community.qlik.com/t5/QlikView/Row-specific-selections/m-p/513486#M191882 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>I am trying to get the bottom most record and then go up five rows and perform an expression calculation.</P><P>For the fourth row from the bottom, I have another calculation and so forth.</P><P>The challenge I found using bottom is that if I say bottom(column xxx, 5) is that it takes the value in the bottom most row in column xxx and replicates it over each row of the bottom five rows.</P><P></P><P>I tried searching for an alternate function but could not find an equivalent. I cannot use rowno() as the number of rows can vary each time.</P><P></P><P>Would appreciate any assistance.</P><P></P><P>Thank you.</P><P><BR /> </P></BODY></HTML> Wed, 23 Oct 2013 14:41:02 GMT https://community.qlik.com/t5/QlikView/Row-specific-selections/m-p/513486#M191882 2013-10-23T14:41:02Z Re: Row specific selections https://community.qlik.com/t5/QlikView/Row-specific-selections/m-p/513487#M191883 <HTML><HEAD></HEAD><BODY><P>Try something like this:</P><P></P><P>pick(NoOfRows()-RowNo()+1,'Bottom','Next to bottom','Nearly bottom','Almost bottom','Close to bottom')</P></BODY></HTML> Wed, 23 Oct 2013 17:54:33 GMT https://community.qlik.com/t5/QlikView/Row-specific-selections/m-p/513487#M191883 Gysbert_Wassenaar 2013-10-23T17:54:33Z Re: Row specific selections https://community.qlik.com/t5/QlikView/Row-specific-selections/m-p/513488#M191884 <HTML><HEAD></HEAD><BODY><P>Thank you so much!</P></BODY></HTML> Thu, 24 Oct 2013 07:58:32 GMT https://community.qlik.com/t5/QlikView/Row-specific-selections/m-p/513488#M191884 2013-10-24T07:58:32Z