topic Re: Using Variables in Load Sentence in QlikView

Using Variables in Load Sentence

Fri, 25 Apr 2014 15:52:43 GMT

Hello Everyone, i have a problem, i want to use a variable into a load sentence.

I declare my variable in this way:

vProceso="31-01-2014";

And I want to use it in the following sentence:

LOAD

vProceso as 'Fecha',

Transacciones as Tran

from

xxxxx;

Also I used $(vProceso) but I didn't get the result.

The table that I will wish to get is:

Fecha Tran

'31-01-2014' 12345

Thanks for help me!!!!

Gysbert_Wassenaar — Fri, 25 Apr 2014 15:58:36 GMT

Try it like this:

SET vProceso= 31-01-2014;

LOAD

'$(vProceso)' as Fecha,

Transacciones as Tran

from

xxxxx;

MK_QSL — Fri, 25 Apr 2014 16:02:50 GMT

May be like below

vProceso= '31-01-2014';

and

'$(vProceso)' as Fecha,

Fri, 25 Apr 2014 16:18:24 GMT

Thanksssss...

MK_QSL — Fri, 25 Apr 2014 16:37:04 GMT

just want to know what is wrong in my answer?

I tried and it's working !

Gysbert_Wassenaar — Fri, 25 Apr 2014 16:48:09 GMT

Yeah, it works. I think it's just better to be explicit about declaring variables by using LET or SET.

MK_QSL — Fri, 25 Apr 2014 17:00:19 GMT

Thanks... ! Have a nice weekend.

Gysbert_Wassenaar — Fri, 25 Apr 2014 17:02:03 GMT

You too!