Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
MarcoWedel

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