Now we are going to put all the pieces together by linking our summarized application to the detailed one and configuring how the integration between them will be done. We will set additional parameters to make sure that our user will make selections and that those selections will be passed to the template script.
Let's begin by adding App navigation links to our summarized application. As discussed in the Building a summarized application section, an on-demand app loads a summarized sample of the data usually using a GROUP BY clause in the SQL or a LOAD statement. To link the summarized app to the template, we need to create App Navigation Links. Let's take a look at how to create these:
- On the left-hand side of the screen in edit mode, you can see an option to create an app link:
- Click on Create new, which will show you the following form:
Fill in the form and create the app link according to the previous image and the following explanation:
-
- Give the link a user-friendly name that makes it easier for users to identify what this link is about.
- Select the template we created in the Building the detailed application section.
- Set an expression that calculates the total number of detailed records that correspond to the current selections made by the user. The expression usually uses the sum function to calculate this value. In our case, we're using sum(trips) since we created this field especially for this.
- Set the maximum value from the last expression set. This is important to prevent the user from retrieving too many rows at once.
- Set the maximum number of apps the user can create; this is important to control how many apps will be created for each user.
- Set a retention time for the generated app. After that time has expired, Qlik Sense will clean up the app. Set it to Never expires if you want to allow the user to manage the apps by themselves.
- Set the default view for the app; you can set it to App overview or a specific sheet.
- Establish whether you want the app to be deployed to a user's work area or a specific stream.
- Drag and drop your application's navigation link to your sheet, placing it in the far bottom of the sheet. Click Done to exit the edit mode:
