Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
theboss-123
Creator II
Creator II
‎2021-08-31 02:25 PM

calculate % increase varation

Hello i have a cross table fsales revenue and i want to display as a graph the increase varation in percent between year  can you help me please 

 

theboss123_0-1630434305642.png

 

223 Views
0 Likes
1 Reply
sunny_talwar
MVP
MVP
‎2021-09-13 10:17 AM

Assuming Year will be the dimension, you can try this

Sum(Measure) / Above(Sum(Measure)) - 1

 Replace Sum(Measure) with the expression you want to calculate percentage increase/decrease

174 Views
0 Likes
Community Browser