What Column Family Options Make Sense for This Data

ix Tips and Tricks for Qlik Sense

Download PDF

I wanted to share with you lot 9 tips and tricks you can implement in your Qlik Sense applications.
The goal is to show you tips that can make your job easier and to highlight features that are not intuitive to find.

Here is the list of tips and tricks that nosotros will find:

1. Different selections in 2 Qlik Sense sheets opened in the same browser
2. Bookmark a sheet with selections
3. Receive a snapshot of a sheet or awarding by email
4. Find a field in the Information Model
5. Get the proper name of the column in a Drill-downward dimension
6. Add a clarification to a chart
7. Create hidden filters
8. Scramble your sensitive data in Qlik Sense
9. Customize a Qlik Sense object with CSS

i- Different selections in two Qlik Sense sheets opened in the same browser

I received a bulletin on LinkedIn and was reminded of Qlik Sense's option that is non used very much. The option is the IDENTITY parameter.

Qlik Sense has several APIs, and one of them is 'Unmarried Integration API.' The Single Integration API provides parameters that tin can be used to create an URL that returns a complete HTML folio containing, for example, an embedded Qlik Sense visualization.

Imagine y'all desire to make dissimilar selections using the same Qlik Sense sheet (two different analysis scenarios)
Yous open the canvas in ii different tabs. Trouble! By default, the selections for sheet i are the aforementioned as for sheet 2

To avoid this, you lot tin can use identity parameter like this:

• In tab i, add at the end of the URL this: /identity/x
• In tab 2, add together at the cease of the URL this: /identity/y

Now the selections in sheet 1 practice not impact sheet 2 and vice versa.

2- Bookmark a canvas with selections

In some cases, users frequently view the same sheet with the aforementioned filters. Example: a salesperson who goes to see his sales results from the mean solar day before every morning. To access this information, the classic path would exist:

• Open Qlik Sense Hub
• Select the sales application
• Select the canvass that corresponds to the sales of the mean solar day before
• Then make the selections or choose an existing bookmark

The easiest manner would exist to create a bookmark in the browser (not a Qlik Sense bookmark). So every day, access the sheet with i click.

To create the bookmark link:

• Open the Qlik Sense sheet
• Brand the selections of your choice
• Go to the menu at the top left of the canvass and choose "Embed sail."
• Click on open preview in the new tab
• Add this URL every bit a favorite

The next time our salesperson wants to access her sales results from the twenty-four hour period before, all he needs to do is click.

three- Receive a snapshot of a canvass or application by email

Now, admitting that our salesperson wants to receive the results of the previous solar day's sales in his inbox every morning in PDF or as an prototype in the email message.

This option is not bachelor in Qlik Sense natively, but with an extension, it is possible.

Use the 100% gratuitous Qalyptus Notify extension. Qalyptus Notify allows y'all to subscribe to a unmarried Qlik Sense sheet or an entire Qlik Sense app. Past subscribing, yous receive a snapshot of a canvas or application as an image or PDF past email at regular intervals without logging into Qlik Sense.

Download Qalyptus Notify

four- Notice a field in the Data model

When you create a complex Qlik Sense awarding with many tables and fields, information technology is necessary to have a articulate and optimized information model. Sometimes you lot want to locate a particular field in the model and, even if possible, meet a preview of the data it contains.

This is easily done in the "Information Model" interface. At the top correct, you can see a magnifying glass push. Click on information technology and enter the proper name of the field you are looking for. Qlik Sense displays the number 1 next to the table that contains information technology. Past selecting it, you likewise accept the possibility to preview its values ​​and several other information.

5- Obtain the proper noun of the column in a Drill-downwardly dimension

For those who have worked with QlikView before, y'all may exist familiar with the GetCurrentField ( group_name ) function. This part is used to brandish the name of the current field in a drill-downwardly dimension.

In Qlik Sense, this function does not exist. To know the proper noun of the current dimension, y'all would have to summate it yourself. Here is an expression for a Hierarchical dimension containing three fields: Land, Region, City.

Expression: =if(count (distinct total Country)> ane, 'Country', if (count (distinct total Region)> 1, 'Region', 'City'))

Depending on the number of fields your drill-downwards dimension contains, create nested if/else respecting the order of the dimensions.

6- Add a description to a chart

One of the all-time practices when creating a Qlik Sense application is to add together a clarification to charts and tables to understand how the result was achieved and requite a clear and detailed definition of the indicator.

For example, if you lot summate the following indicator: Number of active customers. It is interesting to describe the notion of the agile client to avoid ambiguity.

In Qlik Sense, the easiest mode to add a description to an object is to turn it into a Master Item and then add a description in the settings of the Master Detail.

In one case added, you volition see an icon appear in the form of an "i" that displays the object'due south description.

Here's how to do information technology:

• Edit the Master Particular and add a description

• Use the main item in a sheet. Edit it and Switch On "Evidence details."

• Now you can run into the "Show details" button.

7- Create hidden filters

In Qlik Sense, filters are often added to allow users to filter their data easily. Withal, for agronomic reasons, you cannot put many filters on one canvas.

If you desire to let users to access other filters without going through the "Selections" window, which contains all the fields (where the user may exist lost), you can use this trick to hide and display boosted filters.

8- Scramble your sensitive data in Qlik Sense

Sometimes, you want to send a Qlik Sense app exterior of your organisation, and you don't want others to access the information in the app.

In QlikView, in that location is a feature that allows you to choose which fields to scramble, and QlikView transforms the values ​​of these fields into text and numbers, which are random.

Unfortunately, data scrambling is not available as a feature in Qlik Sense at this time.

Here is a postal service that explains how to scramble fields using an Excel file to specify the fields to scramble and a Qlik script that will automatically scramble the fields.

nine- Customize a Qlik Sense object with CSS

This tip is for the smartest developer. Every bit yous know, Qlik Sense is a full web tool, which says web ways HTML / CSS. If you lot desire to customize a Qlik Sense object and don't have the necessary functionality in the object's settings, you can embed CSS code in your canvas and change the fashion of the object.

To accomplish this, you lot would accept to get through the "Multi KPI" object in the born extensions of Qlik Sense. This object contains a text box where yous can enter your CSS lawmaking.

To see in detail how to do this, Christof Schwarz made a very expert video where he explains how to modify a simple table and a pin tabular array.

Run across the video: Styling Sense Tables with Properties and CSS

pearsonrevelf.blogspot.com

Source: https://www.qalyptus.com/blog/tips-and-tricks-for-qlik-sense

Share this post