Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

henster36
New Contributor III

Load Max(Date)

Hi,

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:

[Dates]:

LOAD [Sales Date],

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

Resident [Sales table];

I appreciate your response.

Tags (1)
Community Browser