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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
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