Multivalve in a column to build a filter with single value selection.

[ronaldwang]

I have a column with multivalve in it with a ";" as a separator. For example the value could be A;B;C or A or A;B. how could I manipulate the data in Qliksense so that I could build a filter so that the value in the filter will be A B C for user to choose from. Thanks

[Albarosæ]

Hello,

Do you have access to script? If so, you can use

SubField(YourMultivalueColumn,';') as NewSeperatedFieldToUseAsFilter

[Chanty4u]

try this in script

Sample:
LOAD
YourField,
SubField(YourField, ';') as SingleValue 

from your source;