topic Selecting top record? in QlikView https://community.qlik.com/t5/QlikView/Selecting-top-record/m-p/397495#M148049 <HTML><HEAD></HEAD><BODY><P>Hi, I want to create a variable and set it to a value in a column in a table I am importing, and all the values in this column are the same, so all I would need is the top row's value. In SQL it would be like SELECT TOP 1 @variablename = columnname from tablename. Can anyone show how I would do this in qlikview? Thanks</P></BODY></HTML> Wed, 24 Apr 2013 19:11:10 GMT 2013-04-24T19:11:10Z Selecting top record? https://community.qlik.com/t5/QlikView/Selecting-top-record/m-p/397495#M148049 <HTML><HEAD></HEAD><BODY><P>Hi, I want to create a variable and set it to a value in a column in a table I am importing, and all the values in this column are the same, so all I would need is the top row's value. In SQL it would be like SELECT TOP 1 @variablename = columnname from tablename. Can anyone show how I would do this in qlikview? Thanks</P></BODY></HTML> Wed, 24 Apr 2013 19:11:10 GMT https://community.qlik.com/t5/QlikView/Selecting-top-record/m-p/397495#M148049 2013-04-24T19:11:10Z Re: Selecting top record? https://community.qlik.com/t5/QlikView/Selecting-top-record/m-p/397496#M148050 <HTML><HEAD></HEAD><BODY><P>If you know how to do it in SQL, create the variable in the SQL load table in the script, rather than doing it dynamically - it saves processing time.</P><P></P><P>If you have to do it in Qlikview I would use if(RowNo()=1,Variable).</P></BODY></HTML> Wed, 24 Apr 2013 20:52:05 GMT https://community.qlik.com/t5/QlikView/Selecting-top-record/m-p/397496#M148050 2013-04-24T20:52:05Z