Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Contributor II

Variable Creation

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

2 Replies

Re: Variable Creation

Try this

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

Re: Variable Creation

Num() is wrong because it made from your formatted date a number again. Therefore just leave it:

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

- Marcus