Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
OmarBenSalem

Split one value (exp: A\B\C) into A B C (3 values) within a selection list in the front end(not the script)

Hi guy, stalwar1

Is it possible to split one value into different values based on a seperator?

Exp:

I have this field containing only one value :

Capture.PNG

The seperator is ','

I want to have in this field all the values seperated:

Trade

Delta

IR

CREDIT

etc

is it possible within QLIK SENSE? Is there a function to do so in the FRONT END.

13 Replies
OmarBenSalem
Author

The second one didn't do the trick, the first one returned

1

2

3

4

5

6

7

8

Subfield(myfield,'/') worked fine even in the front end when myfield is a dimension but when I work with a variable vTest it only returns the first value

sunny_talwar

Wanted you to use it in a table (not a filter pane)

OmarBenSalem
Author

Have to do it directly in the front end; and my dimension is a variable:vTest

OmarBenSalem
Author

JUST PERFECT !