Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 ?
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
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.
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