Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead 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:

growth rate.jpg

1 Solution

Accepted Solutions
Not applicable
Author

thanks to both of you

View solution in original post

9 Replies
sunny_talwar

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.

OmarBenSalem

It's exactly what stalwar1‌ proposed:

You should use a combined graph

Capture.PNG

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 %):

Capture.PNG

Result:

Capture.PNG

Not applicable
Author

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

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?

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