Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist II

% Change for 1st record

Hi

I currently have growth rate calculated as below

Revenue: Sum(Revenue)

Growth Rate: (Sum(Revenue)-Above(Sum(Revenue)))/Above(Sum(Revenue))

With this the 1st record is blank/null/NA.

Is there anyway to calculate the growth rate of 1st record.

Note: My selection on Year filter is from 2017 - 2020. If i select an additional year as 2016, it is showing 2015 rate % blank.

Thanks

Satish

1 Solution

Accepted Solutions
Highlighted

You can simplify the equation and use this

Sum(Revenue)/Above(Sum({<Year>}Revenue)) - 1

View solution in original post

2 Replies
Highlighted

Try this

(Sum(Revenue)-Above(Sum({<Year>}Revenue)))/Above(Sum({<Year>}Revenue))

Highlighted

You can simplify the equation and use this

Sum(Revenue)/Above(Sum({<Year>}Revenue)) - 1

View solution in original post