topic % Change for 1st record in QlikView

% Change for 1st record

satishkurra — Tue, 23 Oct 2018 16:10:56 GMT

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

sunny_talwar — Tue, 23 Oct 2018 16:21:34 GMT

Try this

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

sunny_talwar — Tue, 23 Oct 2018 16:22:39 GMT

You can simplify the equation and use this

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