Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
WEBINAR April 23, 2025: Iceberg Ahead: The Future of Open Lakehouses - REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to calculate the % of growth YTY.

Please find the attached QVW.How can I calculate the % of growth (Inccrase or decrease) of Revenue from Year to year ?

Thanks much.

1 Solution

Accepted Solutions
sunny_talwar

Try like this:

Sum(Revenue)/Above(Sum(Revenue)) - 1


Capture.PNG

View solution in original post

3 Replies
sunny_talwar

Try like this:

Sum(Revenue)/Above(Sum(Revenue)) - 1


Capture.PNG

maheshkuttappa
Creator II
Creator II

Slight change in above expression if you want show % growth while selecting single year

Aggr(Sum({1} Revenue)/Above(Sum({1} Revenue)) - 1,Year)

sunny_talwar

Or this, if you need to avoid Aggr() function

(Sum({1}Revenue)/Above(Sum({1}Revenue)) - 1) * Avg(1)