Qlik - 047: Set_Analysis_009: Set Analysis: TOP N Records using functions inside Set Modifier
In this video we will see, how can we use functions inside set modifier which will return members to predefine field values. We will try to get TOP N records for any dimension using Rank and Set Analysis.
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...
Download material for this video from below link. https://drive.google.com/drive/folder...
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 #rank #topnrecords