Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
michielvandegoo
Valued Contributor

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
Valued Contributor

Re: Min and Max date from 8 different columns

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

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

4 Replies
Not applicable

Re: Min and Max date from 8 different columns

show this functiont ---> FIRSTSORTVALUE.

bYE

mARCO

kumarnatarajan
Valued Contributor

Re: Min and Max date from 8 different columns

Hi,

Use "FIRSTSORTEDVALUE" function.

Min Date data:

Syntex = FirstSortedValue(fieldName,date)

Max Date data:

Syntex = FirstSortedValue(fieldName,-date)

michielvandegoo
Valued Contributor

Re: Min and Max date from 8 different columns

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

michielvandegoo
Valued Contributor

Re: Min and Max date from 8 different columns

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

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

Community Browser