Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Growth Calculation

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

Screenshot_1.png

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

Screenshot_2.png

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))

3 Replies
Highlighted
Creator II
Creator II

Hi Friends

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

Screenshot_2.png

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

Highlighted

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

Highlighted
Creator II
Creator II

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