# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for
Did you mean: Not applicable

## 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: 1 Solution

Accepted Solutions Not applicable
Author

thanks to both of you

9 Replies  MVP

May be like this

Sum(Sales)/Above(Sum(Sales)) - 1 Not applicable
Author

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.  MVP

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:  Not applicable
Author

thanks to both of you  MVP

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

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?  MVP

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

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

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 Tags
Community Browser