Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
ronaldwang
Creator III
Creator III

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

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

Labels (1)
2 Replies
Albarosæ
Contributor III
Contributor III

Hello,

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

SubField(YourMultivalueColumn,';') as NewSeperatedFieldToUseAsFilter

 

Chanty4u
MVP
MVP

try this in script

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

from your source;