Qlik - 060 : Set_Analysis_010 : Outer Set Expression (Part 02)

In this video we will see, how can we use Outer Set Expression inside Qlik Set Analysis.

1) Introduction and Lexical Scoping (00:00:01 – 00:04:50)
2) Outer set expression position (00:04:51 - 00:05:00)
3) Context and Inheritance of outer set expression (00:05:01 – 00:08:10)
4) Outer set expression with Aggr() (00:08:11 – 00:12:35)

If you want to read on Set Analysis from Qlik Help
https://help.qlik.com/en-US/sense/May...

Udemy course on Set Analysis
https://www.udemy.com/course/become-a...

If you want to read on Outer Set Expression from Qlik Help
https://help.qlik.com/en-US/sense/Aug...

Must read blogs on Outer Set Expression
Henric : https://community.qlik.com/t5/Design/...
Rob Wunderlich : https://qlikviewcookbook.com/2022/09/...

Download material for this video from below link.
https://drive.google.com/file/d/1-FkR...

Qlik_002 : Set Analysis_001 : Compare Year to Date (YTD) vs Last Year (LY)
   • Qlik_002 : Set Analysis_001 : Compare Year...  

Qlik_017 : Set_Analysis_002 : What is Set Analysis? What are the components of a Set Expression?
   • Qlik_017 : Set_Analysis_002 : What is Set ...  

Qlik_018 : Set_Analysis_003 : How to ignore field selections in Set Analysis?
   • Qlik_018 : Set_Analysis_003 : How to ignor...  

Qlik_019: Set_Analysis_004: Set Analysis: Year to Date (YTD) vs Previous Year to Date (PYTD)
   • Qlik_019: Set_Analysis_004: Set Analysis: ...  

Qlik_020: Set_Analysis_005: Set Analysis: Quarter to Date (QTD) vs Previous Quarter to Date (PQTD)
   • Qlik_020: Set_Analysis_005: Set Analysis: ...  

Qlik_023: Set_Analysis_006: Set Analysis: Month to Date (MTD) vs Previous Month to Date (PMTD)
   • Qlik_023: Set_Analysis_006: Set Analysis: ...  

Qlik_025: Set_Analysis_007: Set Analysis: Week to Date (WTD) vs Previous Week to Date (PWTD)
   • Qlik_025: Set_Analysis_007: Set Analysis: ...  

Qlik_036: Redefining Aggregation Scope using Total Qualifier and Set Analysis Part – 01
   • Qlik_036: Redefining Aggregation Scope usi...  

Qlik_037: Redefining Aggregation Scope using Total Qualifier and Set Analysis Part – 02
   • Qlik_037: Redefining Aggregation Scope usi...  

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 #setmodifier #InnerSetExpression #OuterSetExpression