Discussion Board for collaboration related to QlikView App Development.
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
I know its this field because when I remove it the load works fine.
the date comes in this format
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 ,
Any Help ?
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
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.