Qlik_069: AutoNumber02_How to use AutoNumber() function for composite keys and Link table.

In this video, we will see

1) How to create composite keys and Link Table?
2) How to use AutoNumber() for composite keys?
3) How to use AutoNumber as a statement instead of function?

00:00:00 – 00:01:15 Introduction and table load.
00:01:16 – 00:02:40 Convert MonthYear field to proper datetime/date/daul format.
00:02:41 – 00:03:40 Create composite key.
00:03:41 – 00:07:30 Create link table and remove synthetic key and synthetic table.
00:07:31 – 00:08:45 Implement AutoNumber() function on composite key.
00:08:46 – 00:11:20 Repeat same steps for another table.
00:08:46 – 00:12:40 Implementing AutoNumber() function along with AutoID (2nd parameter)
00:12:41 – 00:16:50 Implementing AutoNumber using Statement.

If you want to read about AutoNumber() function from Qlik help
https://help.qlik.com/en-US/sense/Nov...

If you want to read about AutoNumber statement from Qlik help
https://help.qlik.com/en-US/sense/Aug....

Few good blogs on AutoNumber()
  / qlikview-autonumber-autonumberhash-functio...  
https://qlikviewcookbook.com/2018/04/...
https://www.naturalsynergies.com/q-ti...
http://poverconsulting.com/2014/01/30...
https://www.qlikviewaddict.com/2014/0...
https://community.qlik.com/t5/Design/...

Download content of this video
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 #Genericload #fieldvaluecount #fieldvalue #tablename #loop #forloop #variableswithparameter #aggr #firstsortedvalue #Textbetween #FileList #AutoNumber