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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
jhjzdff
Contributor
Contributor

cant convert datatype to num

I use  adani stock dataset for analysis https://www.kaggle.com/datasets/swaptr/adani-stocks

 I try to convert unix timestamp to normal timstamp , I try to convert timestamp field (text) -> (num)->  date

but I cant convert text to num  type 

 

 

Labels (1)
1 Reply
Aurelien_Martinez
Partner - Specialist II
Partner - Specialist II

Hi,

 

To convert text to num is Num#() founction.

 

To convert epoch I have found this formula :

timestamp((YourEpochDateField/1000/ 86400) + 25569)

Help users find answers! Don't forget to mark a solution that worked for you!