Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have data as:
Year, Sales
2011, 1000
2012, 2000
2013,1500
2014,3000
I want to make a combo chart with Sales as Bar chart and Growth Rate as line chart. Growth is (Current Year Sales- Last year Sales) / Last Year Sales = XX %
Thanks
SAK
Hi,
Checked Enclosed File,
It will Help You,
Regards,
PS
Using PE version .
Can you please send code and screen shots?
Thanks a lot!
BR,
SAK
Hi,
Use Year as Dimension,
Expression
Sales: Sum(Sales)
Growth:=Num((Column(1)-Above(Sum(Sales)))/Above(Sum(Sales)),'#,##0.00%')
OR
=(Column(1)-Above(Sum(Sales)))/Above(Sum(Sales))
the go to Number tab->Fixed to(2)->check Show in Percentage
Regards,
Hi Max,
Thanks a lot. Growth rate is coming fine, but there are two issues:
1. On selection, expression with line chart disappears
2. the growth line is coming very low, indeed at the base of chart and feels like zero change.
Please advise.
Thanks
Shoaib
Hi,
My bad I forgot to tell you one more setting you have to do
Go to ,
Chart Property->Axes->Expression Axes(Select Expression of %)->Position frame( on same tab)->select Right(top).
Regards,
Hi,
And one more thing is that for Growth%
You have to select at least 2 years,
Regards,
PS
Hi Max,
I have years 2011 to 2014. I used this expression
=Sum({<Year={">=$(=Max(Year)-4)<=$(=Max(Year))"}>}Sales) (Year dimension should show all last years | Qlik Community). Celambarasan Adhimulam
If I click on 2013, it's showing all last three years but no growth's calculations. If I select 2012 & 2013, it shows all last three years but growth for 2013 only. If I select all last years, then it shows growth for all years.
Please advise.
Thanks
Shoaib