Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
anushree1
Specialist II
Specialist II

num(date#)

Hi,

I am using CSV File on Qliksense and would like to add 3 days to the date field due to which i am first converting the date to num using the below code, but it results in blank values though order date has valid values, can someone help me on this issue

Num(Date("Order Date", 'DDMMYYYY')) AS NumericDate,

9 Replies
Uday_Pasupuleti
Partner - Creator III
Partner - Creator III

Did you try Num#() ?
anushree1
Specialist II
Specialist II
Author

i did

Uday_Pasupuleti
Partner - Creator III
Partner - Creator III

Try Num#() without the date and see whether it shows any values or not.

If it shows values then use preceding load to convert to a date format.
jood_ahmad
Creator II
Creator II

 try to convert the date to the date num and add the date that you want and if the data has a time stamp try to use the floor function then add the date you need then convert it to the date format 

anushree1
Specialist II
Specialist II
Author

i used num#("Order Date") as num,

it gives me same value as OrderDate,

as i am using Qliksense i cannot change the format in front end on list box as in qlikview to check it actual format

Uday_Pasupuleti
Partner - Creator III
Partner - Creator III

Try
Num(Date(Num#("Order Date"),'DD/MM/YYYY')) as Num
anushree1
Specialist II
Specialist II
Author

its giving me blank values

Uday_Pasupuleti
Partner - Creator III
Partner - Creator III

Will you be able to send that a sample set of data?

Few rows of that field should be good enough.
jood_ahmad
Creator II
Creator II

can you share a sample