Qlik - 059 : Set_Analysis_010 : Outer Set Expression (Part 01)
Qlik - 059: Set Analysis – Outer Set Expression (Part 01)
In this video we will see, how can we use Outer Set Expression inside Qlik Set Analysis.
1) Introduction and inner set expression (00:00:01 – 00:04:00)
2) First use of outer set expression (00:04:01 - 00:04:35)
3) Outer set expression in multiple aggregation function (00:04:36 - 00:07:25)
4) Outer set expression with master measure (00:07:26 – 00:10:45)
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...
Qlik_017 : Set_Analysis_002 : What is Set Analysis? What are the components of a Set Expression?
• Qlik_017 : Set_Analysis_002 : What is...
Qlik_018 : Set_Analysis_003 : How to ignore field selections in Set Analysis?
• Qlik_018 : Set_Analysis_003 : How to ...
Qlik_019: Set_Analysis_004: Set Analysis: Year to Date (YTD) vs Previous Year to Date (PYTD)
• Qlik_019: Set_Analysis_004: Set Analy...
Qlik_020: Set_Analysis_005: Set Analysis: Quarter to Date (QTD) vs Previous Quarter to Date (PQTD)
• Qlik_020: Set_Analysis_005: Set Analy...
Qlik_023: Set_Analysis_006: Set Analysis: Month to Date (MTD) vs Previous Month to Date (PMTD)
• Qlik_023: Set_Analysis_006: Set Analy...
Qlik_025: Set_Analysis_007: Set Analysis: Week to Date (WTD) vs Previous Week to Date (PWTD)
• Qlik_025: Set_Analysis_007: Set Analy...
Qlik_036: Redefining Aggregation Scope using Total Qualifier and Set Analysis Part – 01
• Qlik_036: Redefining Aggregation Scop...
Qlik_037: Redefining Aggregation Scope using Total Qualifier and Set Analysis Part – 02
• Qlik_037: Redefining Aggregation Scop...
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