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

How to modify the 'above' function in the editor?

Hello,

This formula current takes the share percentage delta (difference) from quarter to quarter (Ie, 2017Q2 - 2017Q1):

$(vWtdSharePct)-above($(vWtdSharePct))

Can I modify it to instead look at a difference over a year's period?  Ie, so that it will instead calculate 2017Q2 - 2016Q2 for all data points?

Thank you,

Jeff

1 Solution

Accepted Solutions
sunny_talwar

May be this

$(vWtdSharePct)-Above($(vWtdSharePct), 4)

View solution in original post

2 Replies
sunny_talwar

May be this

$(vWtdSharePct)-Above($(vWtdSharePct), 4)

Not applicable
Author

Thanks Sunny.