How to Build a Dashboard in Qlik Sense: Step-by-Step Guide for 2026

What You’ll Learn

This guide walks you through creating an interactive business dashboard in Qlik Sense from scratch. You’ll load data, build visualizations, apply filters, and publish a dashboard that stakeholders can explore.

Time required: 45-60 minutes
Skill level: Beginner to Intermediate
What you need: Qlik Sense Desktop (free) or Qlik Sense Enterprise subscription, business data in Excel/CSV/database

Step 1: Install Qlik Sense Desktop (Free Version)

Qlik Sense Desktop is a free standalone application for building dashboards on your local machine.

1. Go to qlik.com/us/try-or-buy/download-qlik-sense
2. Click Download Qlik Sense Desktop
3. Fill out the registration form (email required)
4. Download and run the installer
5. Launch Qlik Sense Desktop after installation

Note: Qlik Sense Desktop is Windows-only and limited to local files. For cloud deployment and collaboration, you need Qlik Sense Cloud or Enterprise (paid).

Step 2: Create a New App

In Qlik Sense, dashboards are called “apps.”

1. Click Create new app on the home screen
2. Name your app (e.g., “Sales Dashboard”)
3. Click Create
4. Your blank app opens — you’re now in the App overview screen

Qlik Sense structure:
– App: Container for all your data and visualizations
– Sheet: Individual dashboard page (you can have multiple sheets per app)
– Visualization: Individual chart or table on a sheet

Step 3: Load Your Data

Qlik Sense uses a data model approach — you load data first, then build visuals.

Load from Excel or CSV:

1. Click Add data from files and other sources (or Data manager in the navigation)
2. Select Upload files
3. Click Select files and choose your Excel/CSV file
4. Qlik Sense previews your data
5. Click Add data in the top-right

Data profiling:
– Qlik automatically detects column types (Date, Number, Text)
– Review the Data profiling tab to check quality
– Fix issues now before building dashboards

Load from a database:

1. In Data manager → Add data → select your database type:
2. SQL Server, Oracle, MySQL, PostgreSQL, etc.
3. Enter connection details:
4. Server address
5. Database name
6. Username and password
7. Click Test connection → Create
8. Select tables to import
9. Click Add data

Join multiple tables:

1. After loading the first table, click Add data again
2. Load the second table
3. Qlik Sense auto-detects relationships (if column names match)
4. If not auto-detected:
5. Go to Associations tab
6. Drag to connect related fields (e.g., Orders[CustomerID] to Customers[ID])

Step 4: Create Your First Sheet (Dashboard Page)

1. Click Edit button (top-right) to enter edit mode
2. Click Create new sheet
3. Name your sheet (e.g., “Sales Overview”)
4. Click the sheet to open it

You’re now in the Sheet editor — a blank canvas where you build visualizations.

Step 5: Add a KPI (Single Number Metric)

KPIs show key metrics at the top of your dashboard.

1. In the Assets panel (left side), drag KPI onto the canvas
2. Click Add measure in the properties panel
3. Select Sum → choose your metric field (e.g., Revenue, Orders, Units Sold)
4. The KPI displays the total automatically

Enhance the KPI:
– Add a label: Properties → Labels → turn on title, type “Total Revenue”
– Format the number: Properties → Number formatting → Currency → $1,234.56
– Add a target: Properties → Comparison → Value expression → enter target number

Step 6: Build a Bar Chart

Bar charts are ideal for comparing categories.

1. Drag Bar chart from Assets panel to canvas
2. Configure dimensions:
3. Click Add dimension
4. Select the category field (Product, Region, Sales Rep, etc.)
5. Configure measures:
6. Click Add measure
7. Select Sum → choose your value field (Revenue, Quantity, etc.)
8. Qlik Sense draws the bar chart instantly

Customization:
– Sort bars: Properties → Sorting → Custom → sort by measure descending
– Limit bars shown: Properties → Add-ons → Data handling → Max visible bars → 10
– Change colors: Properties → Colors and legend → choose color scheme
– Add labels: Properties → Presentation → Value labels → On

Step 7: Create a Line Chart (Trend Over Time)

1. Drag Line chart onto canvas
2. Add dimension:
3. Select your date field
4. Qlik Sense auto-groups by month (you can change to day/quarter/year)
5. Add measure:
6. Sum of Revenue, Sessions, Orders, etc.
7. Line chart renders automatically

Pro tips:
– Add a trend line: Properties → Add-ons → Reference lines → Trend line → Enable
– Show multiple metrics: Click Add measure to add a second line
– Change date grouping: Click dimension → dropdown → select Month/Quarter/Year

Step 8: Build a Pivot Table

Pivot tables show data broken down by multiple dimensions.

1. Drag Table or Pivot table onto canvas
2. Add dimensions:
3. Drag multiple dimensions (e.g., Product Category, Month)
4. Rows = primary grouping
5. Columns = secondary grouping (for pivot table)
6. Add measures:
7. Revenue, Profit, Units, etc.
8. Multiple measures create multiple columns

Make it interactive:
– Click any cell → Qlik Sense filters the entire dashboard based on that selection
– Totals: Properties → Presentation → Show totals → Enable

Step 9: Add Filters (Selections)

Qlik Sense’s associative engine lets users filter by clicking any data point, but you can also add explicit filter panels.

Add a list box (filter panel):

1. Drag Filter pane from Assets to canvas
2. Click Add dimension
3. Select fields to filter by (Region, Product, Date, Sales Rep, etc.)
4. Users can now click to filter the entire dashboard

Filter types:
– List box: Shows all unique values as a list
– Dropdown: Saves space for fields with many values
– Range slider: For numeric or date ranges

Pro tip: Place filter panes at the top-left of your dashboard for visibility.

Step 10: Apply Themes and Styling

Qlik Sense offers limited customization compared to Tableau, but you can brand your dashboard.

Apply a theme:

1. Click Prepare (top-right)
2. Click Theme icon
3. Choose from preset themes OR
4. Custom theme: Upload CSS/JSON theme file (advanced)

Format individual charts:

• Select a chart → Appearance tab in properties
• Adjust:
• Colors (by dimension or expression)
• Fonts
• Background colors
• Borders

Brand colors:
– Properties → Colors and legend → Custom → enter HEX codes

Add text and images:

• Text: Drag Text & image object → type title or description
• Logo: Text & image → Background → Image → upload your logo

Step 11: Publish and Share Your Dashboard

Share Qlik Sense Desktop apps (limited):

Qlik Sense Desktop apps are local-only by default. To share:
1. Export the app: File → Export
2. Send the .qvf file to colleagues
3. They open it in their Qlik Sense Desktop

Limitation: No central access, no real-time collaboration.

Share via Qlik Sense Cloud/Enterprise (recommended for teams):

1. Publish your app: Click Publish (top-right)
2. Select a Stream (workspace)
3. Click Publish
4. Share the URL with stakeholders
5. Set permissions: Manage → Security → assign users

Access levels:
– Can view: See the dashboard and interact
– Can edit: Modify the dashboard
– Owner: Full control

Step 12: Set Up Data Refresh

Keep your dashboard up to date with automatic reloads.

Qlik Sense Desktop:

• Open the app → Data manager → Load data button
• Manual reload only (no automatic refresh)

Qlik Sense Cloud/Enterprise:

1. Go to Management Console
2. Create a Reload task for your app
3. Set schedule: Hourly, daily, weekly
4. Qlik reloads data from source automatically

Best practice: Schedule reloads during off-hours to avoid performance impact.

Common Issues and Fixes

Data not updating:
– Qlik Sense loads data into memory (in-memory model)
– You must manually reload data: Data manager → Load data

Associations not detected:
– Qlik auto-associates fields with the same name
– If fields don’t match: Go to Data model viewer → manually link fields

Dashboard slow to load:
– Reduce data volume: Load last 12 months instead of all-time
– Optimize the data model: Combine tables where possible
– Use Section Access to restrict data by user

Visualizations showing wrong totals:
– Check aggregation: Properties → Measure → verify it’s SUM (not COUNT or AVG)
– Data quality issue: Check for duplicates in source data

Qlik Sense vs Other BI Tools

Qlik’s unique feature: The associative engine — click any data point and Qlik instantly shows related and unrelated data. Powerful for exploratory analysis, but requires training to use effectively.

What to Do Next

Level up your Qlik Sense dashboards:
1. Use set analysis: Create advanced calculations (e.g., “sales this year vs last year”)
– Measure expression: Sum({<Year={2026}>} Revenue)
2. Create drill-down dimensions: Let users click to see more detail
– Properties → Dimensions → Add drill-down → select hierarchy (Year → Quarter → Month)
3. Build master items: Reusable measures and dimensions across sheets
– Master items panel → Create new measure → save for reuse

Explore alternatives if Qlik Sense isn’t working:
– Too complex? Try Pulse AI for automated insights or Looker Studio for simpler setup
– Need real-time data? Power BI DirectQuery or Tableau Live connections offer faster refresh
– Budget constraints? Looker Studio is completely free

Frequently Asked Questions

Is Qlik Sense free?

Qlik Sense Desktop is free but limited to local-only dashboards (can’t share online). Qlik Sense Cloud and Enterprise require subscriptions ($15-30/user/month).

What’s the difference between Qlik Sense and QlikView?

• Qlik Sense: Modern, web-based, self-service BI tool (recommended for new users)
• QlikView: Older, desktop-based tool for guided analytics (still supported but not actively developed)

Can non-technical people use Qlik Sense?

Partially. The interface is more intuitive than QlikView, but the data modeling and set analysis require training. Expect a 1-2 week learning curve for basic dashboards, longer for advanced features.

How does Qlik Sense handle large datasets?

Qlik Sense compresses data heavily and stores it in-memory for fast performance. It can handle millions of rows on a standard laptop. For billions of rows, use Qlik Sense Enterprise with a server.

Can I connect Qlik Sense to Salesforce or databases?

Yes. Qlik Sense Desktop connects to Excel, CSV, and databases. Qlik Sense Cloud/Enterprise adds 100+ connectors including Salesforce, Google Analytics, SAP, and more.

What is the “associative engine”?

Qlik’s unique feature: When you click any data point, Qlik shows ALL related data (green) and UNRELATED data (gray). This helps you discover hidden relationships and anomalies that traditional BI tools miss.

How often does Qlik Sense refresh data?

Qlik Sense Desktop: Manual reload only (click “Load data” button)
Qlik Sense Cloud/Enterprise: Set automatic reload schedules (hourly, daily, weekly)

Related guides:
– How to Build a Sales Dashboard in Power BI
– Qlik Sense vs Tableau: Which BI Tool is Right for You?
– Best Qlik Sense Alternatives in 2026