topic Re: Year over Year Growth - Combo chart in QlikView

Year over Year Growth - Combo chart

Thu, 27 Mar 2014 05:27:23 GMT

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

Re: Year over Year Growth - Combo chart

PrashantSangle — Thu, 27 Mar 2014 06:05:28 GMT

Hi,

Checked Enclosed File,

It will Help You,

Regards,

Re: Year over Year Growth - Combo chart

Thu, 27 Mar 2014 06:54:36 GMT

Using PE version .

Can you please send code and screen shots?

Thanks a lot!

BR,

SAK

Re: Year over Year Growth - Combo chart

PrashantSangle — Thu, 27 Mar 2014 07:02:13 GMT

Hi,

Use Year as Dimension,

Expression

Sales: Sum(Sales)

Growth:=Num((Column(1)-Above(Sum(Sales)))/Above(Sum(Sales)),'#,##0.00%')

=(Column(1)-Above(Sum(Sales)))/Above(Sum(Sales))

the go to Number tab->Fixed to(2)->check Show in Percentage

Regards,

Re: Year over Year Growth - Combo chart

Thu, 27 Mar 2014 12:33:17 GMT

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

Re: Year over Year Growth - Combo chart

PrashantSangle — Thu, 27 Mar 2014 12:42:53 GMT

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,

Re: Year over Year Growth - Combo chart

PrashantSangle — Thu, 27 Mar 2014 12:44:23 GMT

Hi,

And one more thing is that for Growth%

You have to select at least 2 years,

Regards,

Re: Year over Year Growth - Combo chart

Thu, 27 Mar 2014 13:07:00 GMT

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