topic Re: Variable in QlikView

Variable

upaliwije — Fri, 14 Dec 2018 17:05:04 GMT

Dear Friends

I have created a variable

vN1=Num(Date(Makedate(2017,12,01),'YYYYMM')) Expected result=201712

How ever it does return the expected result. Kindly Help to get it corrected

Re: Variable

sunny_talwar — Fri, 14 Dec 2018 17:07:11 GMT

Like I mentioned in the other thread... try with Num#() instead of Num()

vN1 = Num#(Date(Makedate(2017,12,01),'YYYYMM'))

Re: Variable

Gysbert_Wassenaar — Fri, 14 Dec 2018 17:08:38 GMT

Remove the Num function. That just removes the formatting that the date function first added. You can use the num# function, but since you assign it to a variable it will make no difference if you do that or not. The variable will contain 201712 in either case.