Discussion Board for collaboration related to Creating Analytics for QlikView.
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.