Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
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.

Knipsel.PNG

2 Replies
vinieme12
Esteemed Contributor II

Re: barplot index figures

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

Hi,

maybe one solution might be:

QlikCommunity_Thread_249539_Pic1.JPG

QlikCommunity_Thread_249539_Pic2.JPG

QlikCommunity_Thread_249539_Pic3.JPG

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

hope this helps

regards

Marco

Community Browser