Qlik - 050: Inter-record functions in Qlik : Previous vs Peek - Part 01
ฝัง
- เผยแพร่เมื่อ 6 ก.พ. 2025
- In this video we will see,
1) Introduction of Inter-record functions (00:00:01 - 00:01:10)
2) Syntax of Previous() function (00:01:11 - 00:02:05)
3) Previous() function at front end (00:02:06 - 00:03-40)
4) Previous() function at back end (00:03:41 - 00:04:45)
5) Replace first row of Previous() with 0 (00:04:46 - 00:05:10)
6) Previous() with Input/Output table example (00:05:11 - 00:08:30)
7) Nested Previous() (00:08:31 - 00:09:58)
8) Previous() function with Order by clause (00:09:59 - 00:14:00)
9) Previous() function with Preceding Load (00:14:01 - 00:15:26)
If you want to read on Previous function from Qlik Help
help.qlik.com/...
If you want to read on Peek function from Qlik Help
help.qlik.com/...
Download material for this video from below link.
drive.google.c...
You can also find me on
TH-cam: / @manishkumarkachhia1683
Facebook: www.facebook.c...
LinkedIn: / manishkachhia
Twitter: / mk_qsl
Udemy: www.udemy.com/...
#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
very nice video its very helpfull
Thank you Sir...
🙏❤️
Hi sir. Your explanation is very Nice. It's cleared all my doubts on Previous function. Also pls make video on AutoNumber,AutoNumberHash128,AutoNumberHash256 with scenario example.
Sure. These topic would be covered soon. They are already on my list.