Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Michiel_QV_Fan
Specialist
Specialist

Min and Max date from 8 different columns

Hi,

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.

Thanks

1 Solution

Accepted Solutions
Michiel_QV_Fan
Specialist
Specialist
Author

RANGEMIN(DATE,DATE,DATE,DATE, ....) AS FIRSTDATE

RANGEMAX(DATE,DATE,DATE,DATE, .... ) AS LASTDATE

View solution in original post

4 Replies
Not applicable

show this functiont ---> FIRSTSORTVALUE.

bYE

mARCO

kumarnatarajan
Partner - Specialist
Partner - Specialist

Hi,

Use "FIRSTSORTEDVALUE" function.

Min Date data:

Syntex = FirstSortedValue(fieldName,date)

Max Date data:

Syntex = FirstSortedValue(fieldName,-date)

Michiel_QV_Fan
Specialist
Specialist
Author

This isn't working because I have to evaluate 8 different columns.

Michiel_QV_Fan
Specialist
Specialist
Author

RANGEMIN(DATE,DATE,DATE,DATE, ....) AS FIRSTDATE

RANGEMAX(DATE,DATE,DATE,DATE, .... ) AS LASTDATE