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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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!