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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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

Try this

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

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