Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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 !