barplot index figures

[#1]

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.

[vinieme12]

Create a YearMonth field as

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

in chart

Add Dimension

MonthYear

Expression something like

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

Reference:Dates in Set Analysis

[MarcoWedel]

Hi,

maybe one solution might be:

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

hope this helps

regards

Marco