Expression for growth %

[upaliwije]

I have in Qv Do the follwing Pivot Table

for the last column I do not get the results expected by me. I want to show % of Cum Increase against based year . That is 2013. and Final table should show following result. Pls help me to modify the expression for the last column.

[MK_QSL]

You have to provide sample data or sample app, otherwise it's difficult to work on this. Hope to get sample data at least

[upaliwije]

Thanks Manish

I gave attched the sampale file Kindly help me

[niclaz79]

Would this work?

Column(3)/(Sum({<CLA_CODE = {'SS'}, FROM_YEAR = {2013}>}PREMIUM)/Sum({<FROM_YEAR = {2013}>}TOTAL_MEMBERS)*100)

[upaliwije]

It does not work

[MK_QSL]

How 0, 2, 4 etc..can you explain?

[MK_QSL · Accepted solution]

If you want to compare and get % based on top row i.e. 2013 then use as below..

(

RangeSum(Above(SUM({<CLA_CODE={'SS'}>}PREMIUM)/SUM(TOTAL_MEMBERS) - Above(SUM({<CLA_CODE={'SS'}>}PREMIUM)/SUM(TOTAL_MEMBERS)),0,RowNo()))

/

TOP(SUM({<CLA_CODE={'SS'},FROM_YEAR={'2013'}>}PREMIUM)/SUM({<FROM_YEAR={'2013'}>}TOTAL_MEMBERS))

)*100

[upaliwije]

Thanks Manish. It works. What does TOP command means ? Pls explain

[MK_QSL]

It will return the value of 1st line of the table...

check bottom as well to understand..

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/InterReco...

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/InterReco...