Hey I am looking to separate out a string like this:
So that i can grab the beginning date : 3/16/2017
and the ending date: 3/17/2017
How do I do this in qliksense Set analysis formula?
I normally have used an indexof to get the comma location and then locate the substring before it to get the startdate, but I am not finding an equivalent in qliksense?
You want to do this on the front end or the backend? I would think that doing this in the backend would make sense or I am not sure I understand what you are looking to do... can you provide more details
I'd suggest doing this in your data model rather than in the front end. This will result in a more flexible solution.
The syntax would be
Subfield([FieldName], ', ', 1) for the first part
or Subfield([FieldName], ', ', 2) for the second