Growth Rate

[#1]

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:

[sunny_talwar]

May be like this

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

[#3]

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.

[OmarBenSalem]

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:

[#5 · Accepted solution]

thanks to both of you

[sunny_talwar]

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

[#7]

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?

[OmarBenSalem]

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]))

[OmarBenSalem]

I misunderstood your KPI:

I thought you were using the graphic above and want to only see the years 2015 to 2017

Here's the expression if you want to compare 2017 % 2015:

(Sum({<Year={'2017'}>}sales)-Sum({<Year={'2015'}>}sales))

/

Sum({<Year={'2015'}>}sales)

[joanaleao]

Hello,

is there a way to have a graph like this but with the possibility to select the years?

because with <Year=> user selection doesn't work and all the years are shown.

Thank you