Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

satishkurra
Valued Contributor 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

Re: % Change for 1st record

You can simplify the equation and use this

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

2 Replies

Re: % Change for 1st record

Try this

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

Re: % Change for 1st record

You can simplify the equation and use this

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