Discussion board where members can get started with Qlik Sense.
Hello everyone, how to write a script to turn T1 into T2. thanks.
subfield(values,',') as values
good， thank you!
For splitting the values in Qlik we have 'Subfield' function.
Subfield (text, delimiter, field_no)
Subfield (FieldName, delimiter, field_no),
Now Let's talk about your table.
Subfield(Values,',',1) as Values
It is better to define field_no in the third parameter.
I have also attached example app. Hopefully, this will solve your problem.
I see, thank you very much.
Please mark as correct if you reach your solution.