Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

New Contributor III

Load Max(Date)


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:


LOAD [Sales Date],

          Max([Sales Date],7) as [Sales Date7]

Resident [Sales table];

I appreciate your response.

Tags (1)
Community Browser