Let's face it - it usually takes a bit longer for features and capabilities of any product to gain traction in an organization. We released On Demand App Generation in 2018 with our Qlik Sense client-managed edition. Frankly I don't have much insight into whom has or has not implemented it. BUT, I can tell you from those that I have spoken with over the years, many were surprised to even see this awesome feature in the product when I brought it up.
However, in older versions, in order to enable it - there were a number of requirements which involved copying data load script along with inserting bindings and variables - which at first glance could be perceived as cumbersome. Even the first time I worked with it, I was a bit overwhelmed. This was true for others as well, so much so, that some Qlik enthusiast even developed web app add-ons and extensions to simplify the process and generate the template for you.
BUT....... since the release of ODAG, just like anything else, it has evolved and is now extremely simple to enable and implement. I show you this process in my latest Do More with Qlik (archive link below) session and summarize the ODAG concept in the latest Qlik Sense in 60 video embedded in this post - so please be sure to check them out. Let me know what you think in the comments below. Stay tuned to my next post where I build on what we learned about ODAG to introduce you to Dynamic Views!
On Demand App Generation - (ODAG - concept)
In summary, ODAG was originally developed to meet the need of analysis of very large data sets. The concept is quite simple:
- One Qlik Sense app displays summarized data with filters from the big data source.
- You select the filter values and reduce your answer set to meet a defined row count constraint.
- You click the app navigation link along the bottom to open the ODAG panel
- You click a button and a new more detailed app, dynamically built from a template, is generated directly from the source data with applied filters and defined metrics at a much more detailed level. That's it!
ODAG Requirements Summarized
- Qlik Sense base app (contains summarized measures as KPIS and desired dimension values as filters)
- Summarized data
- App Navigation link - linked to 2nd Qlik Sense template app
- Defined row count constraint
- App retention setting
- Qlik Sense template app (contains detail KPIs and detailed analysis metrics)
- Activation script with binding syntax
- WHERE conditions with odag_ binding variables added to query
Qlik Sense in 60 - On Demand App Generation (video)
(Video transcript attached)
Help Topics
https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/LoadData/using-OnDem...
Source data:
https://www1.nyc.gov/site/tlc/about/tlc-trip-record-data.page
Presentation:
Do More with Qlik Session - you may need to register to access it:
https://gateway.on24.com/wcc/experience/eliteqliktech/1910644/2395144/do-more-with-qlik-for-beginner...
Register:
https://pages.qlik.com/21Q3_QDEV_DA_GBL_DoMorewithQlikTargetpage_Registration-LP.html
Sample Apps attached - ODAG - Apps - Taxi Trips.zip - (Note you need to add your data connection and access SQL etc to your data sources)
Can't see the video? YouTube blocked by your region or organization? Download the .mp4 attached in this post to view this on your computer or mobile device.
ODAG - Apps - Taxi Trips.zip
