Discussion board where members can get started with Qlik Sense.
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.
Would this suffice ?
Assuming your field OrderOpenDate is a true Qlik Date and not just a text field.
Thanks Bill that worked perfectly.