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.<\/p>\n
Time required:<\/strong> 45-60 minutes Qlik Sense Desktop is a free standalone application for building dashboards on your local machine.<\/p>\n Note:<\/strong> Qlik Sense Desktop is Windows-only and limited to local files. For cloud deployment and collaboration, you need Qlik Sense Cloud or Enterprise (paid).<\/p>\n In Qlik Sense, dashboards are called “apps.”<\/p>\n Qlik Sense structure:<\/strong> Qlik Sense uses a data model approach \u2014 you load data first, then build visuals.<\/p>\n Data profiling:<\/strong> You’re now in the Sheet editor<\/strong> \u2014 a blank canvas where you build visualizations.<\/p>\n KPIs show key metrics at the top of your dashboard.<\/p>\n Enhance the KPI:<\/strong> Bar charts are ideal for comparing categories.<\/p>\n Customization:<\/strong> Pro tips:<\/strong> Pivot tables show data broken down by multiple dimensions.<\/p>\n Make it interactive:<\/strong> Qlik Sense’s associative engine lets users filter by clicking any data point, but you can also add explicit filter panels.<\/p>\n Filter types:<\/strong> Pro tip:<\/strong> Place filter panes at the top-left of your dashboard for visibility.<\/p>\n Qlik Sense offers limited customization compared to Tableau, but you can brand your dashboard.<\/p>\n Brand colors:<\/strong> Qlik Sense Desktop apps are local-only<\/strong> by default. To share: Limitation:<\/strong> No central access, no real-time collaboration.<\/p>\n Access levels:<\/strong> Keep your dashboard up to date with automatic reloads.<\/p>\n Best practice:<\/strong> Schedule reloads during off-hours to avoid performance impact.<\/p>\n Data not updating:<\/strong> Associations not detected:<\/strong> Dashboard slow to load:<\/strong> Visualizations showing wrong totals:<\/strong> ## \u26a1 FASTER ALTERNATIVE: Skip the Data Loading and Chart Building<\/p>\n **Qlik Sense is powerful but complex.** Loading data, modeling relationships, and building every chart manually takes time. If you’re spending more time configuring Qlik than analyzing data, consider an AI-first approach.<\/p>\n **[Pulse AI](https:\/\/usepulseai.com)** connects to your data sources and generates dashboards automatically. Just ask “show me sales by region this quarter” and it builds the visual instantly \u2014 no data modeling, no manual chart configuration.<\/p>\n **Key differences:** **Ideal for:** Teams that need answers fast without learning complex BI tools<\/p>\n
\nSkill level:<\/strong> Beginner to Intermediate
\nWhat you need:<\/strong> Qlik Sense Desktop (free) or Qlik Sense Enterprise subscription, business data in Excel\/CSV\/database<\/p>\n
\nStep 1: Install Qlik Sense Desktop (Free Version)<\/h2>\n
\n
\nStep 2: Create a New App<\/h2>\n
\n
\n– App:<\/strong> Container for all your data and visualizations
\n– Sheet:<\/strong> Individual dashboard page (you can have multiple sheets per app)
\n– Visualization:<\/strong> Individual chart or table on a sheet<\/p>\n
\nStep 3: Load Your Data<\/h2>\n
Load from Excel or CSV:<\/h3>\n
\n
\n– Qlik automatically detects column types (Date, Number, Text)
\n– Review the Data profiling<\/strong> tab to check quality
\n– Fix issues now before building dashboards<\/p>\nLoad from a database:<\/h3>\n
\n
Join multiple tables:<\/h3>\n
\n
Orders[CustomerID]<\/code> to Customers[ID]<\/code>)<\/li>\n<\/ol>\n
\nStep 4: Create Your First Sheet (Dashboard Page)<\/h2>\n
\n
\nStep 5: Add a KPI (Single Number Metric)<\/h2>\n
\n
\n– Add a label:<\/strong> Properties \u2192 Labels<\/strong> \u2192 turn on title, type “Total Revenue”
\n– Format the number:<\/strong> Properties \u2192 Number formatting<\/strong> \u2192 Currency \u2192 $1,234.56
\n– Add a target:<\/strong> Properties \u2192 Comparison<\/strong> \u2192 Value expression<\/strong> \u2192 enter target number<\/p>\n
\nStep 6: Build a Bar Chart<\/h2>\n
\n
\n– Sort bars:<\/strong> Properties \u2192 Sorting<\/strong> \u2192 Custom<\/strong> \u2192 sort by measure descending
\n– Limit bars shown:<\/strong> Properties \u2192 Add-ons<\/strong> \u2192 Data handling<\/strong> \u2192 Max visible bars<\/strong> \u2192 10
\n– Change colors:<\/strong> Properties \u2192 Colors and legend<\/strong> \u2192 choose color scheme
\n– Add labels:<\/strong> Properties \u2192 Presentation<\/strong> \u2192 Value labels<\/strong> \u2192 On<\/p>\n
\nStep 7: Create a Line Chart (Trend Over Time)<\/h2>\n
\n
\n– Add a trend line:<\/strong> Properties \u2192 Add-ons<\/strong> \u2192 Reference lines<\/strong> \u2192 Trend line<\/strong> \u2192 Enable
\n– Show multiple metrics:<\/strong> Click Add measure<\/strong> to add a second line
\n– Change date grouping:<\/strong> Click dimension \u2192 dropdown \u2192 select Month\/Quarter\/Year<\/p>\n
\nStep 8: Build a Pivot Table<\/h2>\n
\n
\n– Click any cell \u2192 Qlik Sense filters the entire dashboard based on that selection
\n– Totals:<\/strong> Properties \u2192 Presentation<\/strong> \u2192 Show totals<\/strong> \u2192 Enable<\/p>\n
\nStep 9: Add Filters (Selections)<\/h2>\n
Add a list box (filter panel):<\/h3>\n
\n
\n– List box:<\/strong> Shows all unique values as a list
\n– Dropdown:<\/strong> Saves space for fields with many values
\n– Range slider:<\/strong> For numeric or date ranges<\/p>\n
\nStep 10: Apply Themes and Styling<\/h2>\n
Apply a theme:<\/h3>\n
\n
Format individual charts:<\/h3>\n
\n
\n– Properties \u2192 Colors and legend<\/strong> \u2192 Custom<\/strong> \u2192 enter HEX codes<\/p>\nAdd text and images:<\/h3>\n
\n
\nStep 11: Publish and Share Your Dashboard<\/h2>\n
Share Qlik Sense Desktop apps (limited):<\/h3>\n
\n1. Export the app: File<\/strong> \u2192 Export<\/strong>
\n2. Send the .qvf file to colleagues
\n3. They open it in their Qlik Sense Desktop<\/p>\nShare via Qlik Sense Cloud\/Enterprise (recommended for teams):<\/h3>\n
\n
\n– Can view:<\/strong> See the dashboard and interact
\n– Can edit:<\/strong> Modify the dashboard
\n– Owner:<\/strong> Full control<\/p>\n
\nStep 12: Set Up Data Refresh<\/h2>\n
Qlik Sense Desktop:<\/h3>\n
\n
Qlik Sense Cloud\/Enterprise:<\/h3>\n
\n
\nCommon Issues and Fixes<\/h2>\n
\n– Qlik Sense loads data into memory (in-memory model)
\n– You must manually reload data: Data manager<\/strong> \u2192 Load data<\/strong><\/p>\n
\n– Qlik auto-associates fields with the same name
\n– If fields don’t match: Go to Data model viewer<\/strong> \u2192 manually link fields<\/p>\n
\n– Reduce data volume: Load last 12 months instead of all-time
\n– Optimize the data model: Combine tables where possible
\n– Use Section Access<\/strong> to restrict data by user<\/p>\n
\n– Check aggregation: Properties \u2192 Measure<\/strong> \u2192 verify it’s SUM (not COUNT or AVG)
\n– Data quality issue: Check for duplicates in source data<\/p>\n
\n
\n– **Pulse AI:** Natural language \u2192 instant dashboard (30 seconds)
\n– **Qlik Sense:** Data loading + modeling + chart building (45-60 minutes)<\/p>\n
\nQlik Sense vs Other BI Tools<\/h2>\n
\n\n
\n \nFeature<\/th>\n Qlik Sense<\/th>\n Power BI<\/th>\n Tableau<\/th>\n Pulse AI<\/th>\n<\/tr>\n<\/thead>\n \n Price<\/strong><\/td>\n Free (Desktop) or $15-30\/user\/month (Cloud\/Enterprise)<\/td>\n $10-20\/user\/month<\/td>\n $15-70\/user\/month<\/td>\n Free tier available<\/td>\n<\/tr>\n \n Setup time<\/strong><\/td>\n 45-60 min<\/td>\n 60+ min<\/td>\n 60+ min<\/td>\n 30 seconds<\/td>\n<\/tr>\n \n Data model<\/strong><\/td>\n In-memory (pre-loaded)<\/td>\n Import or DirectQuery<\/td>\n Extract or Live<\/td>\n Live queries<\/td>\n<\/tr>\n \n Learning curve<\/strong><\/td>\n Medium-High<\/td>\n High<\/td>\n High<\/td>\n Very Low<\/td>\n<\/tr>\n \n Associative engine<\/strong><\/td>\n Yes (unique to Qlik)<\/td>\n No<\/td>\n No<\/td>\n No<\/td>\n<\/tr>\n \n