8 Replies Latest reply: Mar 23, 2017 11:56 AM by omar bensalem

# Growth Rate

I need an expression that returns de growth rate in QLIK SENSE  combo chart. the expression must be connected to the Date and sales table.

I´m going to show an example:

• ###### Re: Growth Rate

May be like this

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

• ###### Re: Growth Rate

No.

I have to use an expression that return the dates in date column to years (bar chart) and secondary axis is a line with an expression like the example in excel i have shown for growth rate.

• ###### Re: Growth Rate

It's exactly what stalwar1 proposed:

You should use a combined graph

as dimension : Year

As measures:

1) Sum({<Year=>}sales)

2) (Sum({<Year=>}[sales])-above(Sum({<Year=>}[sales])))

/

above(Sum({<Year=>}[sales])) : choose representation Line and it must be a secondary axis (format it as %):

Result:

• ###### Re: Growth Rate

thanks to both of you

• ###### Re: Growth Rate

What is the point of marking a thank you response as a correct answer? Might as well leave it open....

• ###### Re: Growth Rate

I used the same expression to build a KPI showing the growth rate between 2015-2017, but the result was wrong.

(Sum({<Year={'2015'}>}[sales])-above(Sum({<Year={'2017'}>}[sales])))/above(Sum({<Year={'2017'}>}[sales]))

Can you help me?

• ###### Re: Growth Rate

You should proceed as this:

1) measure 1 :  Sum({<Year={"<=2017 >=2015"}>}sales)

2) (Sum({<Year={"<=2017 >=2015"}>}[sales])-above(Sum({<Year={"<=2017 >=2015"}>}[sales])))

/

above(Sum({<Year={"<=2017 >=2015"}>}[sales]))