Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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