topic Re: Expression for growth % in QlikView

Expression for growth %

upaliwije — Wed, 04 Apr 2018 08:26:01 GMT

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.

Re: Expression for growth %

MK_QSL — Wed, 04 Apr 2018 08:31:10 GMT

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

Re: Expression for growth %

upaliwije — Wed, 04 Apr 2018 08:47:51 GMT

Thanks Manish

I gave attched the sampale file Kindly help me

Re: Expression for growth %

niclaz79 — Wed, 04 Apr 2018 08:54:38 GMT

Would this work?

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

Re: Expression for growth %

upaliwije — Wed, 04 Apr 2018 09:00:16 GMT

It does not work

Re: Expression for growth %

MK_QSL — Wed, 04 Apr 2018 09:12:06 GMT

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

Re: Expression for growth %

MK_QSL — Wed, 04 Apr 2018 09:17:44 GMT

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

Re: Expression for growth %

upaliwije — Wed, 04 Apr 2018 09:36:13 GMT

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

Re: Expression for growth %

MK_QSL — Wed, 04 Apr 2018 10:00:37 GMT

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/InterRecordFunctions/top.htm

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/InterRecordFunctions/bottom.h…