Input Variable multiple value --> add rows

[hd94]

Hello, 

I use an input variable and i want to add rows depend numbers values separate by ';'. 

If i put one value in my input variable : i want this , it's working

but when i put 2 values 

I want this result , i tried with subfield in the table. 

toto | 971880

toto| 971940

titi | 971880

titi | 971940

Someone can help me. 

Thanks a lot. 

[vinieme12]

try 

(toto|titi)

refer this article for more

https://community.qlik.com/t5/Qlik-Design-Blog/The-Expression-Search/ba-p/1463907

[abhijitnalekar]

Hi @hd94 ,

you can achieve the same using the subfield function.

Please refer to the below links.

https://community.qlik.com/t5/QlikView-App-Dev/Convert-Comma-Separated-column-value-to-rows/m-p/1181...

https://community.qlik.com/t5/QlikView-App-Dev/split-comma-separated-values-in-column-into-rows/td-p...

[hd94]

I tried with (toto|titi) , and subfield(field, '|') it's not working. 

[hd94]

I read this two Topics, with a load in a script, i already used the subfield, it's ok,  but with an input variable in my sheet it's not working. 

Do you have an idea ? 

[vinieme12]

If your field is a string value like   'toto;titi;something;somethingelse'    then you need to split them in the load script not in the chart

DataTable:

Load 

field

subfield(field,';')  as newfield

From YourDataSource;

Then just use newfield in your charts ; 

 What exactly are trying to achieve with the variable?