topic Re: Growth Calculation in QlikView

Growth Calculation

upaliwije — Thu, 14 Sep 2017 15:47:00 GMT

In the Pivot table shown below I want to calculate the growth of nos over the year 2016

After the calculation of growth out put report should look like below

My expression for Nos is as follows

sum(Nos)

Year is a dimension

I tried following expression to calculate growth but it does not work. Pls help

if(RISK_YEAR=2017,(sum({<RISK_YEAR={'2017'}>} Nos)-sum({<RISK_YEAR={'2016'}>} Nos)),sum({<RISK_YEAR={'2016'}>} Nos))

upaliwije — Thu, 14 Sep 2017 16:59:51 GMT

Hi Friends

I manage to calculate growth my pivot table now looks as shown below

My expression for growth is (Sum(Nos)/Before(Sum({<RISK_YEAR>}Nos)) - 1) * Avg(1)

However There is blank Column (3 rd Column ) which I want to hide. Can you suggest a solution please

sunny_talwar — Thu, 14 Sep 2017 17:01:48 GMT

We have done the Pick(Dim(....)) approach so many times before... are you still not able to implement it?

upaliwije — Fri, 15 Sep 2017 04:53:48 GMT

Hi Sunny,

I tried with this Expression

IF(match(YEAR,'2017'),(Sum(Nos)/Before(Sum({<RISK_YEAR>}Nos)) - 1) * Avg(1))

still the blank row appears