Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

shannoypaul
Contributor

Multiple Values in Input Field

Hi all,

If I am using an input field, any method to do a bulk load of values other than manually keying in the values.

TIA.

2 Replies

Re: Multiple Values in Input Field

Not clearly understood , Can you explain in details??

Regards,

Regards,
Prashant Sangle
rahulpawarb
Valued Contributor II

Re: Multiple Values in Input Field

Hello Shannoy,

If you want to assign a list of values to a input filed then follow below approach:

- Create a variable in script and assign a list of values to it separated by comma

//Manual Approach

SET vMulti = 'Alpha, Bravo, Charlie, Delta';

//Dynamic Approach

Test:

LOAD * INLINE [

Name,Amount

Alpha,10

Bravo,20

Kilo,10

Lima,18

Mike,35

];

TempConcat:

LOAD Concat(Name,', ') as TempName

Resident Test

Where Amount  < 20;

 

Let vMulti = FieldValue('TempName',1);

Drop Table TempConcat;

Hope this will help.

Regards!

Rahul Pawar

Community Browser