How to display charts based on a selection in QlikView

Sometimes your requirement demands that you display charts based on user selection. it is very easy to accomplish this task in QlikView.

Steps to display charts based on selection in QlikView

1. Connect to the data source. In my example i will be loading data from an excel sheet

2. Create an Inline table for the charts you want to display

3. Create two charts – BarChart and a TrendChart

4. Set a condition on the Layout tab of the charts

5. Create a list box for chart type selection

As a first step, i will load the data from excel
1. Open QlikView desktop and go to script editor by using ctrl + E

2. From the data section at the bottom,click on Table Files and browse to your file

TableFile 3. Click reload to load the data

4. On the script editor, add a new tab from the menu and create an Inline table for BarChart and TrendChart.

InlineLoad

Creating Bar chart and LineChart

1. Right click on the sheet and select New sheet object and chart.

2. On the General tab,Select Bar chart which is the first chart in Chart Types.

3. Select City as Dimension and expression as Sum(Profit)

4.  Navigate to Layout tab and under Show option specify the following condition

Layout1

 

6. To create Line Chart, copy the Bar chart by clicking over the chart, press ctrl and drag the chart. You can also use copy paste to make a copy of the chart

7. In the Layout tab of the Line Chart, specify the following condition

ChartType = ‘TrendChart’

  • Make sure the spelling of ChartType , BarChart and TrendChart matches exactly what you have defined in the Inline table

8. Create a listbox for ChartType

ListBox

You dashboard is ready,where based on a selection you can display your charts

DisplayingBar

 

Curious to know how to do this in Tableau visit How to display a chart based on selection in Tableau

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.