topic Multi value variable in QlikView

Multi value variable

micheledenardi — Thu, 29 Jan 2015 15:55:18 GMT

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

Re: Multi value variable

Gabriel — Thu, 29 Jan 2015 16:04:30 GMT

Hi,

Use Subfield function to split them as you wish.

=Subfield(MultiVariable,',',1)

Hope this help

Re: Multi value variable

Anonymous — Thu, 29 Jan 2015 16:17:06 GMT

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

Re: Multi value variable

micheledenardi — Thu, 29 Jan 2015 16:33:47 GMT

Thank Gabriel ! you are right !!!