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

ความคิดเห็น • 5

  • @aamerkhan5643
    @aamerkhan5643 ปีที่แล้ว

    very nice video its very helpfull

  • @KennySamaita
    @KennySamaita ปีที่แล้ว

    Thank you Sir...

  • @wissawattaesuji
    @wissawattaesuji 6 หลายเดือนก่อน

    🙏❤️

  • @vinodjadhav7334
    @vinodjadhav7334 2 ปีที่แล้ว

    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.

    • @manishkumarkachhia1683
      @manishkumarkachhia1683  2 ปีที่แล้ว +2

      Sure. These topic would be covered soon. They are already on my list.