topic Re: Percentage expression in QlikView

Percentage expression

priyarane — Thu, 10 Dec 2015 10:11:43 GMT

Hi Community,

How to get percentage for this expression in straight table

(sum({<%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'}>}RWA)

/sum({<%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'}>}EAD))

(sum({<%Month = {'$(=$(=vPrevMonth))'}, %Year = {'$(=$(=vPrevYear))'}>}RWA)

/sum({<%Month = {'$(=$(=vPrevMonth))'}, %Year = {'$(=$(=vPrevYear))'}>}EAD))

Re: Percentage expression

karthikeyan1504 — Thu, 10 Dec 2015 10:16:14 GMT

In number format, please check 'Show in percentage' option

Re: Percentage expression

Chanty4u — Thu, 10 Dec 2015 10:18:15 GMT

hi,

Re: Percentage expression

Anonymous — Thu, 10 Dec 2015 10:18:30 GMT

what respect you want?

you can do it, like

(CurrentMonth-PreviousMonth)

CurrentMonth

(CurrentMonth-PreviousMonth)

PreviousMonth

depends on your requirement

Re: Percentage expression

priyarane — Thu, 10 Dec 2015 10:24:44 GMT

actula requirement for RWA% is

sum(rwa)/Sum(ead) then we will change it to % in number tab

but here we have current and previous both, so I have confused

Re: Percentage expression

karthikeyan1504 — Thu, 10 Dec 2015 10:27:35 GMT

((sum({<%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'}>}RWA)

/sum({<%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'}>}EAD)))

((sum({<%Month = {'$(=$(=vPrevMonth))'}, %Year = {'$(=$(=vPrevYear))'}>}RWA)

/sum({<%Month = {'$(=$(=vPrevMonth))'}, %Year = {'$(=$(=vPrevYear))'}>}EAD)))

Try above and have the number format in percentage

Re: Percentage expression

Anonymous — Thu, 10 Dec 2015 10:29:06 GMT

Then I doubt for same that with mentioned expression you will get RWA%?

Re: Percentage expression

tyagishaila — Thu, 10 Dec 2015 10:29:35 GMT

Hi Priya,

If you want to show relative percentage (Row wise sum/ total sum)

check Option Relative (Chart properties -> Expression -> Click on checkbox Relative)

Re: Percentage expression

Anonymous — Thu, 10 Dec 2015 10:31:25 GMT

what is the mean of vPrevMonth w.r.t vPrevYear...??

I think It should be like..

vCurrMonth w.r.t vPrevYear...

vPrevMonth w.r.t vCurrYear...

Re: Percentage expression

priyarane — Thu, 10 Dec 2015 10:41:12 GMT

I wanted show this, RWA/EAD = RWA%

above all not worked out

Re: Percentage expression

Anonymous — Thu, 10 Dec 2015 10:45:37 GMT

From your snap shot, it seems you are having label EAD and RWA of both expression, is it?

If yes, simply write:

Label of RWA expression i.e RWA / EAD(Label of EAD expression)

and then select relative from Expression Tab for this expression

Hope this will help!!

Re: Percentage expression

Anonymous — Thu, 10 Dec 2015 10:48:36 GMT

see the attachment

Re: Percentage expression

tyagishaila — Thu, 10 Dec 2015 11:08:44 GMT

did you not get any value in RWA% column, or you get wrong values.

if you get values thn to convert these values into %

go to Chart Propertis -> Number -> Click check box Show in Percentage.

Re: Percentage expression

priyarane — Thu, 10 Dec 2015 11:35:17 GMT

in this case percentages are wrong

rwa/ead * 100

Re: Percentage expression

Anonymous — Thu, 10 Dec 2015 11:41:18 GMT

no need to multiply by 100..

Just divide RWA label / EAD Label

and select relative option for that expression

Re: Percentage expression

tyagishaila — Thu, 10 Dec 2015 11:47:27 GMT

use Show in Percentage,

are you using correct formula to get RWA%,

it may be, RWA / (RWA+EAD)