Qlik Sense App – How To Create a Qlik Sense Application
1. Objective – Qlik Sense App
Earlier, we saw how to install Qlik Sense. Today, we will see the Qlik Sense App. Moreover, we will look at creating a Qlik Sense Application. It is time for you to learn how to create your first Qlik Sense App.
So, let’s start the tutorial for Creating Qlik Sense App.
You can download the dataset used in this blog here
2. Creating Qlik Sense Application
i. Logging in
Step 1: Once after installing Qlik Sense Desktop, you need to log in with your account as an authorized user. Choose the first option if you are using the free version otherwise select the ‘Add authentication link’ option.
Step 2: Now, you will be asked to enter the username and password of the Qlik Sense account.
Step 3: As soon as you log in, you will enter the Qlik Sense Hub where the option ‘Create a new app’ will appear. Select that option.
ii. Creating a New App
a. Step 1: Naming the App
The first step in creating an app is assigning a name to the application. Enter the name as per your liking.
b. Step 2: Adding Data
Now we enter the newly created application. As you can see, there is an option given at the very center to add data from files. Select that option to load data from external sources.
c. Step 3: Selecting the File Path
In the window opened now, there are many pre-existing databases you can connect and fetch data from. But for now, we want to load data from a file residing in the system. So, we select the option My Computer in the File Locations section.
All the drives in your device will be shown in a list. You can select the one in which the data file of your interest lies. Keep select into the folders until you find your data file. The Path bar will show all the folders you have entered defining a file path.
d. Step 4: Data Loading
As soon as you click on the file from which you want to load data, the data table will appear. If the first columns are not field names, then select Embedded field names from the Field names option. If you fine with all the adjustments, then click on Add Data button (green in color) at the bottom right of the pane.
A message will show confirm the successful data loading and displaying the elapsed time.
The mainsheet will also show all the fields names from the loaded table on the section at the left.
e. Step 5: Creating a Visualization
Now, using the loaded data, we will create some visualizations like charts and tables. For this, go to the Edit icon. You will enter the edit mode.
From the data file having some product’s sales details, we will create three types of visualizations from the Charts menu given in the right section of the edit mode. To place the visualization on the editing pane, just select the chart type, drag to the central pane and drop it wherever you want to place it.
As you can see, we have created a table box and a bar chart. We will also create a Combo chart.
The empty space in the orange box is the activated combo chart in which we need to add the dimension and measures. Select the dimension and measure fields of your choice from the list of fields given in the options ‘Add dimension’ and ‘Add measure’. Now, the chart will display some visuals. From the exploration menu given at the right of the central editing pane, you can further modify the dimensions and measures. You can add expressions to be applied on measures and give them labels.
Step 6: Resizing and arranging visualizations.
As you can in the image give below, we have changed the position of the combo chart we just created and placed it at the bottom. You can also resize these objects very easily by dragging the corners of the orange box in or out. Also, you can set which colors or color gradient the bars of the chart are going to show from the Appearance option given at the left section. You can also manage the settings of x and y-axis of the graphs.
f. Step 7: Final Visualizations
As soon as you click Done in the Editor when you are done with adding and create the visualization, the visualizations will appear on the main sheet view.
As you can see in the image above, we have created three visualizations. One bar chart with horizontally oriented bars showing the total sold units of each product line. The second is a simple table which shows the total cost or sales amount for each product line type. And, at the bottom is a combo chart which shows the total number of sold units of each product category type.
You can analyze data better by making searches and selections. By the virtue of the associative model, where all the relevant fields and their values are associated with each other can be filtered. In our sheet, the result of the selection we made can be seen in the image below. We selected the ‘Food, Beverages & Tobacco’ bar from the chart which filtered and displayed only the relevant data values.
So, this was all in how to create the application in Qlik Sense. Hope you like our explanation.
We hope now you can create apps in Qlik Sense on your own. Go start exploring this interested and extremely user-friendly software. Practice and explore until we meet for our next lesson, learning a new thing about Qlik Sense.
Still, if you have any confusion, ask in the comment tab.
See also –