Creating first QlikSense application

QlikSense is a new addition to the Qlik’s family.

To learn more about QlikSense visit What is QlikSense

In this article, i want to show how to get started on building a simple application in Qlik Sense

To develop QlikSense app , download QlikSense desktop

After a successful download of QlikSense desktop, start QlikSense and you will see Sense Hub.

Hub is  a collection of all the Sense applications. You will also use the hub to create new apps.

Sense_Hub

Steps to create a QlikSense Application

1. Open QlikSense desktop, you will arrive at hub

2. Select “Create new app” (refer screen shot above) and name your application

3.Once you open your created app, Add data

Adding data

4. In select data source screen, you can select or connect to any kind of data source.For this application, I will select Excel

SelectDataSource5. Browse to the data file you want to use and click next. You will get a “Add data” sheet. Here you can Filter/add tables in excel sheet. You can also filter , select and un- select fields.

AddTables

6. Select Profile to get Table association recommendations. Since I have selected 2 tables. Sense is recommending the associations to be made between the fields. If you are familiar with QlikView then you can relate to association.

DataProfiling

AssociationRecommendations

7. After checking your data associations and load the data. You will get the option of edit the sheet. Click on edit sheet

8.Use Data Manager to Edit or Add data sources.

DataManager

 

9. I will add dimensions for Product and Categories. Profile option will show the data associations. You can rename columns to remove the undesired associations

Profiling3

10. After the Data is loaded, its time to create/edit  sheet

NewSheet2

11. To create visualizations, drag and drop objects on the sheet. Refer screen shot above

12. By using, different visualizations and properties, you can get started on creating a nice Sense application

MyFirstSheet

4 thoughts on “Creating first QlikSense application

  1. Wilber López Ordoñez says:

    Dear Chandraish Sinha. Actually I am learnig Qlik Sense doing some samples in Qlick Sense Cloud.

    I would do your sample. Could you share the source excel file with orders and orders_detail please?.
    lopezwilber@hotmail.com

    Thanks a lot

    • Chandraish Sinha says:

      Lopez:
      Thanks for your interest.
      I will email you the source excel files to your mail id.

  2. What if we want to automate this process of daily excel load in qliksense

  3. To automate the reload process on a daily basis we can use QlikSense Enterprise Edition rather than QlikSense Desktop. QlikSense Enterprise has a task scheduler in the Management Console that allows you to reload the app on a daily or monthly or hourly basis.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.