Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator 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
sunny_talwar
MVP
MVP

Try this

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

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