Discussion Board for collaboration on QlikView Scripting.
I have a case where I need to create a column the maximum value that is in another column.
The data looks like this:
The goal is to get a column with the max date in every cell:
I have a big data set and multiple sheets, so I need to make the operation nice and easy.
Thank you guys!
max(Date) as MaxDate
Drop table temp;
'$(vMaxDate)' as Date,
try some thing like this
LOAD Date(Date#(Date,'DD.MM.YYYY')) as Date, Data INLINE [
LOAD Date(max(Date)) as MaxDate Resident Table1;
Use, MaxDate as Dimension.
Please see the attached one
Please find the attached QVW file.I have done it at script level.