Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
michielvandegoo
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
michielvandegoo
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
Partner

Hi,

Use "FIRSTSORTEDVALUE" function.

Min Date data:

Syntex = FirstSortedValue(fieldName,date)

Max Date data:

Syntex = FirstSortedValue(fieldName,-date)

michielvandegoo
Specialist
Specialist
Author

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

michielvandegoo
Specialist
Specialist
Author

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

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

View solution in original post