topic Multiple Values in Input Field in QlikView

Multiple Values in Input Field

shannoypaul — Wed, 26 Jul 2017 06:21:03 GMT

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.

PrashantSangle — Wed, 26 Jul 2017 06:40:36 GMT

Not clearly understood , Can you explain in details??

Regards,

rahulpawarb — Wed, 26 Jul 2017 07:00:19 GMT

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