Multi value variable

[micheledenardi]

hi,

i have a problem with multi value variable that qlik show me as: 'value1;value2;value3'  as a single string

there is a function that allow me to split every value of this variable ?   (es. 'value1' 'value2' 'value3')

thank's

[Gabriel · Accepted solution]

Hi,

Use Subfield function to split them as you wish.

=Subfield(MultiVariable,',',1)

Hope this help

[Anonymous]

Hi,

Try:

Left('$(vValue)', Index('$(vValue)', ';')-1) as value1,
Mid('$(vValue)', Index('$(vValue)', ';')+1, 3) as value2,
Right('$(vValue)', Len('$(vValue)')-Index('$(vValue)', ';', 2)) as value3

[micheledenardi]

Thank Gabriel ! you are right !!!