Qlik - 057: How to get Date and Time from a TimeStamp?
In this video we will see, how to we can get Date and Time from a TimeStamp field
1) How to check a field is interpreted as TimeStamp or not? (00:00:01 – 00:02:40)
2) How to use Floor, Ceil and Frac? (00:02:41 – 00:04:15)
3) How to use Floor and Frac on TimeStamp field at front end (00:04:16 – 00:07:05)
4) How to use Floor and Frac on TimeStamp at back end (00:07-06 – 00:07:58)
5) How to Interpret TimeStamp field and use Floor and Frac on it (00:07:59 – 00:11:14)
If you want to read on Floor() function from Qlik Help
https://help.qlik.com/en-US/sense/May...
If you want to read on Ceil() function from Qlik Help
https://help.qlik.com/en-US/sense/May...
If you want to read on Frac() function from Qlik Help
https://help.qlik.com/en-US/sense/May...
Check Interpretation and Formatting functions videos
• Qlik - 048: Interpretation functions ...
• Qlik - 049: Interpretation functions ...
You can also find me on
YouTube: / @manishkumarkachhia1683
Facebook: https://www.facebook.com/profile.php?...
LinkedIn: / manishkachhia
Twitter: / mk_qsl
Udemy: https://www.udemy.com/user/manish-kac...
#qlik #qliksense #qlikview #qs #qv #qlikdatamodel #qlikscript #set #let #setvariable #letvariable #variable #newtoqlik #newtoqliksense #newtoqs #newtoqlikview #newtoqv #learnqlik #beginnerqlik #trace #tracestatement #debug #Trace #tablefunctions #qlikfunctions #qlik #fieldname #fieldnumber #nooffields #noofrows #nooftables #qvd #storeqvd #createqvd #addyears #addmonths #date #time #dateandtimefunctions #monthstart #monthend #yearstart #yearend #pick #match #customisedreport #pivottable #networkdays #sql #sqlconnection #sqldataconnection #forloop #foreachloop #qvd #createqvd #aggregation #Total #MappingLoad #ApplyMap #MapUsing #NestedApplyMap #numberformat #incremental #incrementalload #deltaload #insertonlyincrementalload #insertandupateincrementalload #insertupdateanddeleteincrementalload #Date #DateHash #Intrepretation #Formatting #interrecord #peek #previous #above #below #TimeStamp