Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Ashlabita
Contributor
Contributor

YOY sales comparison with % growth

Hi There, I need to generate a chart include year on year sales comparison with % growth Please help
2 Solutions

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

Need more details to help properly but from a high level you should be able to use above function.

e.g. =(sum(Sales)/Above(sum(Sales))-1) with year as dimension will give you year on year growth

check manual below

https://community.qlik.com/t5/QlikView-Documents/Missing-Manual-Above-and-Below/ta-p/1481948

View solution in original post

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

Need more details to help properly but from a high level you should be able to use above function.

e.g. =(sum(Sales)/Above(sum(Sales))-1) with year as dimension will give you year on year growth

check manual below

https://community.qlik.com/t5/QlikView-Documents/Missing-Manual-Above-and-Below/ta-p/1481948