topic Re: Concatenate variable-value in QlikView

Concatenate variable-value

atafsson — Tue, 30 Oct 2012 14:02:36 GMT

Hi,

I'd like to concatenate the value from a variable into a table. How do I do??

I tried this, but it does'nt work:

LET Domain1 = 'COMPANYNAME';

LET User1 = 'USERNAME1';

TAB:

LOAD * INLINE [

    domain2, user2

    DOMÄNTEST, ANVTEST
];

Concatenate (TAB)
load '$(Domain1)' as domain2,
         '$(User1)' as user2
;

Re: Concatenate variable-value

MayilVahanan — Tue, 30 Oct 2012 14:15:15 GMT

Try like this

LET Domain1 = 'COMPANYNAME';

LET User1 = 'USERNAME1';

TAB:

LOAD * INLINE [

domain2, user2

DOMÄNTEST, ANVTEST

];

load '$(Domain1)' as domain2,

'$(User1)' as user2 Resident TAB;

Hope it helps

Re: Concatenate variable-value

atafsson — Tue, 30 Oct 2012 14:24:53 GMT

Thank you Mayil!

Re: Concatenate variable-value

Anonymous — Tue, 30 Oct 2012 14:42:54 GMT

i have same requirement but bit different. i want field values of list boxes changes upon selection of different buttons (using variable)

the reason why i need this is i'm conditionally enabling the expresions based of list box fields

plz find the attached sample application

Thanks in Advance

have a good day

Re: Concatenate variable-value

MayilVahanan — Tue, 30 Oct 2012 14:54:40 GMT

Are you want something like attached file?

Re: Concatenate variable-value

Anonymous — Tue, 30 Oct 2012 15:01:10 GMT

thanks got it