topic Load Max(Date) in QlikView

topic Load Max(Date) in QlikView https://community.qlik.com/t5/QlikView/Load-Max-Date/m-p/459623#M485837 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>how can I load the 7 maximum dates in my table as 'n seperate field? My script expression currently looks as follows but I'm getting an error when reloading:</P><P></P><P>[Dates]:</P><P>LOAD [Sales Date],</P><P>          Max([Sales Date],7) as [Sales Date7]</P><P>Resident [Sales table];</P><P></P><P>I appreciate your response.</P></BODY></HTML> Wed, 20 Mar 2013 10:12:50 GMT Anonymous 2013-03-20T10:12:50Z Load Max(Date) https://community.qlik.com/t5/QlikView/Load-Max-Date/m-p/459623#M485837 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>how can I load the 7 maximum dates in my table as 'n seperate field? My script expression currently looks as follows but I'm getting an error when reloading:</P><P></P><P>[Dates]:</P><P>LOAD [Sales Date],</P><P>          Max([Sales Date],7) as [Sales Date7]</P><P>Resident [Sales table];</P><P></P><P>I appreciate your response.</P></BODY></HTML> Wed, 20 Mar 2013 10:12:50 GMT https://community.qlik.com/t5/QlikView/Load-Max-Date/m-p/459623#M485837 Anonymous 2013-03-20T10:12:50Z