Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How do i get the first date in a selection of a range of dates

Hi Guys

I'm trying to get the first date in a date selection. The selection can be from one to any number of dates.

Mid(Getfieldselections ( OrderOpenDate,',' ),3,10) works fine for the first 6 selections, after that I get '7 of 173' instead of the dates.

Is there any way I can get a list or a range back from the GetFieldsSelection.

All I have managed to get back are:

The first 2 work fine but the 3rd result wont work for me.

Thanks.

2 Replies
Anonymous
Not applicable
Author

Would this suffice ?

     Date(Min(OrderOpenDate))

Assuming your field OrderOpenDate is a true Qlik Date and not just a text field.

Anonymous
Not applicable
Author

Thanks Bill that worked perfectly.