topic Re: Convert variable to numeric value in QlikView

Convert variable to numeric value

tmumaw — Wed, 21 Sep 2016 12:06:23 GMT

Morning everybody,

Simple one for you I have a variable vWKEND that I what to make numeric.

LET vWKEND = peek('WEDAT', 0, 'CurrentDate');

I need to make vWKEND numeric....not too sure about the syntax to do this.

I tried this one with no luck:

Num('$(vWKEND)') as NumWkend;

Thanks

Re: Convert variable to numeric value

Anonymous — Wed, 21 Sep 2016 12:10:59 GMT

what Format is WEDAT?

have you tried: week($(vWKEND))

Re: Convert variable to numeric value

tmumaw — Wed, 21 Sep 2016 12:16:58 GMT

Here is part of my script. I thought I would try creating another variable to pass throughout the script, but for some reason it does not like my syntax....something really simple I know.

CurrentDate:
LOAD FISPD,
FISYR,
[Billing Date],
WEDAT,
WKNO
FROM (qvd)
where [Billing Date] = '$(vToday)';

LET vFisYr = peek('FISYR', 0, 'CurrentDate');
LET vFisPd = peek('FISPD', 0, 'CurrentDate');
LET vWkNo = peek('WKNO', 0, 'CurrentDate');
LET vWKEND = peek('WEDAT', 0, 'CurrentDate');

Num(Date($(vWKEND), 'YYYY-MM-DD')) AS vNumWkend;

DROP TABLE CurrentDate;

Re: Convert variable to numeric value

Wed, 21 Sep 2016 12:21:56 GMT

Any of the below statement should work.

LET vWKEND = Evaluate(peek('WEDAT', 0, 'CurrentDate'));

LET vWKEND = Num(peek('WEDAT', 0, 'CurrentDate'));

Re: Convert variable to numeric value

Anonymous — Wed, 21 Sep 2016 12:23:18 GMT

try

Num(Date('$(vWKEND)', 'YYYY-MM-DD')) AS vNumWkend;

what Format is WEDAT?

Re: Convert variable to numeric value

neelamsaroha157 — Wed, 21 Sep 2016 12:26:48 GMT

Or LET vWkNo = Num(peek('WKNO', 0, 'CurrentDate'));

Re: Convert variable to numeric value

tmumaw — Wed, 21 Sep 2016 12:28:42 GMT

I am getting an error unknown statement

Re: Convert variable to numeric value

tmumaw — Wed, 21 Sep 2016 12:33:09 GMT

Thanks.....

Re: Convert variable to numeric value

Anonymous — Wed, 21 Sep 2016 12:34:32 GMT

sorry, I didnot read exactly

you cannot assign a variable to other variable using as!

you should use

Let vNumWkend=Num(Date('$(vWKEND)', 'YYYY-MM-DD'))

or you directly use

Let vNumWkend=Num(Date(peek('WEDAT', 0, 'CurrentDate'), 'YYYY-MM-DD'))