topic Re: Get the indexOf a char in a string in Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Get-the-indexOf-a-char-in-a-string-in-Set-Analysis/m-p/1308896#M843957 <HTML><HEAD></HEAD><BODY><P>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</P></BODY></HTML> Wed, 12 Apr 2017 15:48:35 GMT sunny_talwar 2017-04-12T15:48:35Z Get the indexOf a char in a string in Set Analysis https://community.qlik.com/t5/QlikView/Get-the-indexOf-a-char-in-a-string-in-Set-Analysis/m-p/1308894#M843955 <HTML><HEAD></HEAD><BODY><P>Hey I am looking to separate out a string like this: </P><P>'3/16/2017,3/17/2017'</P><P></P><P>So that i can grab the beginning date : 3/16/2017</P><P>and the ending date: 3/17/2017</P><P></P><P>How do I do this in qliksense Set analysis formula?</P><P>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? </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Get-the-indexOf-a-char-in-a-string-in-Set-Analysis/m-p/1308894#M843955 bekahbeets 2020-11-25T16:16:04Z Re: Get the indexOf a char in a string in Set Analysis https://community.qlik.com/t5/QlikView/Get-the-indexOf-a-char-in-a-string-in-Set-Analysis/m-p/1308895#M843956 <HTML><HEAD></HEAD><BODY><P>$(=index('3/16/2017,3/17/2017',','))</P><P></P><P>but what do you want to achieve with that?</P></BODY></HTML> Wed, 12 Apr 2017 15:47:59 GMT https://community.qlik.com/t5/QlikView/Get-the-indexOf-a-char-in-a-string-in-Set-Analysis/m-p/1308895#M843956 Anonymous 2017-04-12T15:47:59Z Re: Get the indexOf a char in a string in Set Analysis https://community.qlik.com/t5/QlikView/Get-the-indexOf-a-char-in-a-string-in-Set-Analysis/m-p/1308896#M843957 <HTML><HEAD></HEAD><BODY><P>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</P></BODY></HTML> Wed, 12 Apr 2017 15:48:35 GMT https://community.qlik.com/t5/QlikView/Get-the-indexOf-a-char-in-a-string-in-Set-Analysis/m-p/1308896#M843957 sunny_talwar 2017-04-12T15:48:35Z Re: Get the indexOf a char in a string in Set Analysis https://community.qlik.com/t5/QlikView/Get-the-indexOf-a-char-in-a-string-in-Set-Analysis/m-p/1308897#M843958 <HTML><HEAD></HEAD><BODY><P>Hi Rebekah,</P><P></P><P>I'd suggest doing this in your data model rather than in the front end. This will result in a more flexible solution.</P><P></P><P>The syntax would be</P><P>Subfield([FieldName], ', ', 1) for the first part</P><P>or Subfield([FieldName], ', ', 2) for the second</P><P></P><P>Marcus</P></BODY></HTML> Wed, 12 Apr 2017 15:49:10 GMT https://community.qlik.com/t5/QlikView/Get-the-indexOf-a-char-in-a-string-in-Set-Analysis/m-p/1308897#M843958 marcus_malinow 2017-04-12T15:49:10Z Re: Get the indexOf a char in a string in Set Analysis https://community.qlik.com/t5/QlikView/Get-the-indexOf-a-char-in-a-string-in-Set-Analysis/m-p/1308898#M843959 <HTML><HEAD></HEAD><BODY><P>... but I would recommend doing this at script level... I never used it in the frontend like that...</P></BODY></HTML> Wed, 12 Apr 2017 15:52:12 GMT https://community.qlik.com/t5/QlikView/Get-the-indexOf-a-char-in-a-string-in-Set-Analysis/m-p/1308898#M843959 Anonymous 2017-04-12T15:52:12Z Re: Get the indexOf a char in a string in Set Analysis https://community.qlik.com/t5/QlikView/Get-the-indexOf-a-char-in-a-string-in-Set-Analysis/m-p/1308899#M843960 <HTML><HEAD></HEAD><BODY><P>I normally have done something like substring('string1,string2', 0, indexOf(',')) to get the string1, but i think qliksense's subfield() will do the same thing</P></BODY></HTML> Wed, 12 Apr 2017 15:53:52 GMT https://community.qlik.com/t5/QlikView/Get-the-indexOf-a-char-in-a-string-in-Set-Analysis/m-p/1308899#M843960 bekahbeets 2017-04-12T15:53:52Z Re: Get the indexOf a char in a string in Set Analysis https://community.qlik.com/t5/QlikView/Get-the-indexOf-a-char-in-a-string-in-Set-Analysis/m-p/1308900#M843961 <HTML><HEAD></HEAD><BODY><P>the range is set on the front end so i have to work with the range on the front end.</P></BODY></HTML> Wed, 12 Apr 2017 15:54:26 GMT https://community.qlik.com/t5/QlikView/Get-the-indexOf-a-char-in-a-string-in-Set-Analysis/m-p/1308900#M843961 bekahbeets 2017-04-12T15:54:26Z Re: Get the indexOf a char in a string in Set Analysis https://community.qlik.com/t5/QlikView/Get-the-indexOf-a-char-in-a-string-in-Set-Analysis/m-p/1308901#M843962 <HTML><HEAD></HEAD><BODY><P>That is perfect and the actual end goal I am trying to acheive! Thank you!</P></BODY></HTML> Wed, 12 Apr 2017 15:55:35 GMT https://community.qlik.com/t5/QlikView/Get-the-indexOf-a-char-in-a-string-in-Set-Analysis/m-p/1308901#M843962 bekahbeets 2017-04-12T15:55:35Z