Discussion Board for collaboration on QlikView Scripting.
How can I find the min date and the max date from my data?
I have 1 unique ID with 8 different date fields. Some fields are empty.
To fill my kalender right I need a single field with all unique possible dates from those 8 columns.
Go to Solution.
RANGEMIN(DATE,DATE,DATE,DATE, ....) AS FIRSTDATE
RANGEMAX(DATE,DATE,DATE,DATE, .... ) AS LASTDATE
show this functiont ---> FIRSTSORTVALUE.
Use "FIRSTSORTEDVALUE" function.
Min Date data:
Syntex = FirstSortedValue(fieldName,date)
Max Date data:
Syntex = FirstSortedValue(fieldName,-date)
This isn't working because I have to evaluate 8 different columns.