Month: March 2014

Buiding a simple QlikView Dashboard

Posted on Updated on

Creating visualizations/dashboards in QlikView follow a two step process – first collating the data from different sources and modifying them according to the requirement (data preparation) followed by building the actual UI.

1. Data preparation

Adding all data sources and labeling it using the SQL-like format in the edit pane

1_qv

Displaying the fields corresponding to the data set being loaded

2_qv

Checking if the load is successful by displaying certain fields

3_qv

Adding two new fields – Year and Month in the Sales data (for creating hierarchy)

4_qv

2. Building the User Interface

Adding a background image

5_qv

Adding a multi-box

6_qv

From different chart types, we will use a line chart see year-on-year sales trends

11_qv

Styles in line chart:

7_cv

Using Groups for drilling down into hierarchical data (ex.: year to quarter to month)

8_cv

Restricting the number of values shown in the chart (while not showing others) – uncheck “Show Others”

9_cv

Using a container object to build a layout and create a basic Qlikview document to analyze sales data

10_cv