topic barplot index figures in QlikView

barplot index figures

Sat, 11 Feb 2017 12:17:14 GMT

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.

Re: barplot index figures

vinieme12 — Sun, 12 Feb 2017 12:56:06 GMT

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

Re: barplot index figures

MarcoWedel — Sun, 12 Feb 2017 23:23:48 GMT

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