topic Convert a String to a List of Strings in App Development

Convert a String to a List of Strings

alutz54 — Thu, 11 May 2023 20:54:57 GMT

I have a string that looks like "MAY,APR,MAR,FEB,JAN,DEC" but I want it to be a list of strings separated on the comma so that I can pass the list as a variable into a future SQL SELECT.

Re: Convert a String to a List of Strings

alutz54 — Fri, 12 May 2023 13:33:18 GMT

Do I have to create a table and do a Load SubField(Field,',') as [List of Strings]?

Re: Convert a String to a List of Strings

Kushal_Chawda — Fri, 12 May 2023 13:41:56 GMT

@alutz54 you have string but how it is stored? Is it stored in one of the column in table? If so how does column value looks like. Do you want to create a list from that column?

Re: Convert a String to a List of Strings

alutz54 — Fri, 12 May 2023 13:47:35 GMT

Sorry, I am creating a variable of the previous 6 fiscal periods so that I can use that variable to filter a future SQL SELECT. So the string is stored as a variable that I created is stored as a variable.

Re: Convert a String to a List of Strings

MarcoWedel — Fri, 12 May 2023 16:22:28 GMT

Are you looking for something like this?

SET string = '"MAY,APR,MAR,FEB,JAN,DEC"'; LET strings = Replace(string,',','","');

Re: Convert a String to a List of Strings

alutz54 — Fri, 12 May 2023 17:03:09 GMT

Yes! The Replace function is exactly what I was looking for. Thank you, I am very new to Qlik Sense. If I may ask one more question, I have a SQL SELECT later on in this code where I am using the above list of strings as a filter in a WHERE clause. How would I reference the strings variable? The $(strings) format is not working.

Re: Convert a String to a List of Strings

Kushal_Chawda — Fri, 12 May 2023 22:43:57 GMT

@alutz54 If you are going to use this string in SQL query not sure if double code works so instead try single quotes

SET string = '"MAY,APR,MAR,FEB,JAN,DEC"'; LET strings = replace(Replace(string,',',''','''),'"',chr(39));

Re: Convert a String to a List of Strings

Chanty4u — Sat, 13 May 2023 04:54:01 GMT

Try this

LET string = 'MAY,APR,MAR,FEB,JAN,DEC';

LET strings = Chr(39) & Replace(string, ',', Chr(39) & ',' & Chr(39)) & Chr(39);

LOAD *

FROM YourTable

WHERE Month IN ($(strings));