Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 :
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.
Something along these lines
Dimension
ValueLoop(1, SubStringCount(Alpha, ',')
Expression
=SubField(Alpha, ',', ValueLoop(1, SubStringCount(Alpha, ',')))
I've tried with
=subfield( vTest,',')
(the field is a variable)
but the result was as follow:
You might be able to use ValueLoop with subfield... but what exactly are you trying to do?
As I told you Sunny,
I have a filter called "ALPHA" that contains only one value: a,b,c,d,f,g,h (for exp)
I want to split this value into different ones, to have :
ALPHA:
a
b
c
d
f
g
h
as a filter..
Even if you do manage to split it in the Front End that will not change any associations that exists in your data model.
To be able to use it as a filter you will have to split it during the data load .
vinieme12 is right, even if you are able to split... selections won't be the way you would want.... what is your use case here?
Yes I know, it's just a way of viewing things that matters in this case
The subfield(myfield,'/') as myfield2 does the trick when It's performed in the script:
but I HAVE to do this directly in the front end.
Something along these lines
Dimension
ValueLoop(1, SubStringCount(Alpha, ',')
Expression
=SubField(Alpha, ',', ValueLoop(1, SubStringCount(Alpha, ',')))
You can load a small island table then to use as a listbox
List:
Load Subfield(Alpha,',') as Alpha2
Resident XXX;