Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
zztop8970
Contributor
Contributor

How to create a new dimension as a calculated field

I have a table that look like this - 

zztop8970_0-1707853954334.png

 

I would like to create a new column, Annual growth that would show for each customer how much they grew year-over-yers, i.e get to this state - 

zztop8970_1-1707854054071.png

Is there a Qlik function to do this

Labels (1)
1 Reply
vinieme12
Champion III
Champion III

use Above()

= Sales% - Above(Sales%)

https://help.qlik.com/en-US/sense/November2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Inter...

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.