Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

pzwonford
New Contributor II

Earliest date

Hi guys,

I have a file with customer information

NI number

Forename

Surname

Date purchased car

Date purchased house

Date purchased van

I'd like to be able to pull out the earliest date between date purchased car, date purchased house and date purchased van. For example see below

NI numForenameSurnameDate purchased cardate purchased houseDate purchased vanEarliest
111111BobSmith01/01/201405/05/201401/08/201401/01/2014

Can this be done?

1 Solution

Accepted Solutions

Re: Earliest date

=Date(RangeMin([Date purchased car],[date purchased house],[Date purchased van]))

2 Replies
ecolomer
Honored Contributor II

Re: Earliest date

use the function Min(date)

Re: Earliest date

=Date(RangeMin([Date purchased car],[date purchased house],[Date purchased van]))

Community Browser