topic Re: share of the amount in total in App Development

share of the amount in total

ShahbazovT — Fri, 02 Apr 2021 08:44:10 GMT

Hi experts. I need your help🙏

I want to create new column and to find share of LCY amounts on each balance sheet line.

for example LCY / (LCY+FCY) by gross loan portfolio

LCY / (LCY+FCY) by retail loan portfolio etc

I checked this formulas but did not give the desired result:

Sum({<TRN_DT={"*2020-11-27*"},Currency={'LCY'}>} OUTSTANDING_BALANCE_LCY ) / Sum(Total {<TRN_DT={"*2020-11-27*"}>} OUTSTANDING_BALANCE_LCY )

LCY & FCY amounts are located in the same column

Please help🙏

brunobertels — Tue, 01 Dec 2020 11:55:56 GMT

Try this

before(Column(1))
/(before(Column(1))+Column(1))

ShahbazovT — Tue, 01 Dec 2020 12:39:29 GMT

Thanks for the help Bruno.

Please, can you explain over the column name of my table? I could not do that

or it must be in this form (before(Column(1)) / (before(Column(1))+Column(1)))

because the formula did not work in such a form

brunobertels — Tue, 01 Dec 2020 16:58:35 GMT

Hi ,

before sending you this formula i test it in one of my pivot table object in qliksense and it worked well

I saw that you have 2 column in your pivot table and if I well understand your requirement you need to get the ratio of LCY on the sum of LCY + FCY.

LCY is your first column so it is before(column(1)) and FCY is your second column so it column(1)

then your formula

LCY / (LCY+FCY)

firstColumn/ ( firstColumn + SecondColumn)

can be written like that :

before(column(1)) / ( before(column(1)) + column(1) )

this formula won't work :

(before(Column(1)) / (before(Column(1))+Column(1)))

So it work's for me but if I expand the dimension it does'nt work anymore

Sorry we may search another solution

ShahbazovT — Wed, 02 Dec 2020 12:59:39 GMT

Dear Bruno,

LCY & FCY amounts are located in the same column.