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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s