Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

barplot index figures

Hello there fellow Qlickers,

I was wondering if anyone could advise me on how to create a visualisation as shown below.

I have a dataset filled with 4 years of data entries that i like to use to show either growth or decline compared to the same months in previous years, seen from year x. 

The main question to me is how to set the dimension to create this visualisation.

the next step for me would be to make it dynamic, so that the visualisation will always show me the status of previous month.


2 Replies
Esteemed Contributor II

Re: barplot index figures

Create a YearMonth field as

Date(MonthStart(Date),'MMM-YY') as MonthYear

in chart

Add Dimension


Expression something like

Sum( {$<MonthYear={"$(=Date(AddMonths(Max(Month),-1),'MMM-YY'))"}  Amount )

Reference:Dates in Set Analysis

Re: barplot index figures


maybe one solution might be:




Num((Sum({$<month={"$(=Only(Month(month)))*"}>} Fact)-Sum(TOTAL Fact))/Sum(TOTAL Fact),'0.0%')

hope this helps



Community Browser