Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
anwarbham
Contributor III
Contributor III

Convert Date to number crashing Qlik senseServer

Hi I am experiencing strange behaiviour

in Qlik view I have a simple etl where I am trying to convert a date time to number 

here is the field in question

Num#(Date(ConvertToLocalTime(Email_Sent_Date_vod__c,'GMT-05:00'),'DD/MM/YYYY')) as JustDateNum,

Qlik view creates the QVD but when I go and try and read it in Qlik sense , it crashes the engine.

and in QMC I can see an engine error

 
 

70701f83-a541-4531-8014-824ccefccac9.jpg

 

image.png

 

I know its this field because when I remove it the load works fine.

the date comes in this format 

2020-07-01 00:10:40.000

 

which in number is 44013

 

I need it to be 30/06/2020 and then in number format 

strange thing is the following fields don't cause  the error

ConvertToLocalTime(Email_Sent_Date_vod__c,'GMT-05:00')as Email_Sent_Date_vod__c ,

Num(subfield(replace(Email_Sent_Date_vod__c,'.',','),',',1))as %Calendar_Key, 

 

Any Help ?

 

 

 

Labels (3)
1 Solution

Accepted Solutions
anwarbham
Contributor III
Contributor III
Author

fixed it by using the following 

 

subfield(Num(subfield(replace(ConvertToLocalTime(Email_Sent_Date_vod__c,'GMT-05:00'),'.',','),',',1)),'.',1) as %Calendar_Key, 

 

now it does not crash 

View solution in original post

2 Replies
rubenmarin

Hi, have you tried to use Num() instead of Num#()?

Num#() is used to specify the input format of a number, Num() to convert a value to number.

anwarbham
Contributor III
Contributor III
Author

fixed it by using the following 

 

subfield(Num(subfield(replace(ConvertToLocalTime(Email_Sent_Date_vod__c,'GMT-05:00'),'.',','),',',1)),'.',1) as %Calendar_Key, 

 

now it does not crash 

View solution in original post