Qlik - 048: Interpretation functions vs Formatting functions in Qlik. Date vs Date# (Part 01)
In this video we will see,
1) Data types in Qlik (00:00:01 – 00:01:00)
2) How Qlik is storing Dates (00:01:01 – 00:02:45)
3) Gregorian Calendar and number for each date (00:02:46 – 00:03-50)
4) Qlik functions to handle date and time (00:03:51 – 00:05:45)
5) When and how to use Interpretation function (00:05:46 – 00:17:50)
6) When and how to use Formatting function (00:17:51 – 00:23:45)
If you want to read on Formatting functions from Qlik Help
https://help.qlik.com/en-US/sense/May...
If you want to read on Interpretation functions from Qlik Help
https://help.qlik.com/en-US/sense/May...
Three good blog post from Henric Cronstrom on the same topic.
https://community.qlik.com/t5/Qlik-De...
https://community.qlik.com/t5/Qlik-De...
https://community.qlik.com/t5/Qlik-De...
Download material for this video from below link.
https://drive.google.com/drive/folder...
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