Рет қаралды 2,537
In this video, we will see how to get rolling 3 months total, rolling 6 months total. We will also see how to get rolling 3 months and rolling 6 months average. This total/average would work even after selecting dimensions.
You can directly jump to relevant sections from below timeline.
1) Introduction (00:00:01 - 00:00:38)
2) Explanation of Rolling Total and Rolling Average (00:00:39 - 00:04:08)
3) Rolling 3 Months Total and Rolling 6 Months Total (00:04:09 - 00:07:30)
4) Adding Set Expression and Aggr inside Rolling Period expression (00:07:31 - 00:10:30)
5) Rolling 3 Months Average and Rolling 6 Months Average (00:10:31 - 00:12:13)
Udemy Set Analysis Course
www.udemy.com/...
Download material for this video from below link.
drive.google.c...
Qlik - 054: Inter-record functions in Qlik : Above() and Below()
• Qlik - 054: Inter-reco...
Qlik - 055: Range functions in Qlik : RangeSum, RangeMin, RangeMax
• Qlik - 055: Range func...
Qlik - 056: Cumulative Total in Qlik using Range functions and Inter-record functions
• Qlik - 056: Cumulative...
You can also find me on
KZbin: / @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