topic Re: % Calculation in QlikView

% Calculation

upaliwije — Thu, 21 Sep 2017 16:22:21 GMT

Hi Friends

I have written following expression and bus It does not calculate the % correctly. Pls help me correct my expression

if(RENEWED_PREMIUM=0 or (RENEWED_REFUNDS*1)=RENEWED_PREMIUM,SUM( RENEWABLE_PREMIUM))

/if(RENEWED_PREMIUM=0 or (RENEWED_REFUNDS*1)=RENEWED_PREMIUM,SUM(TOTAL<REASON> RENEWABLE_PREMIUM))

sunny_talwar — Thu, 21 Sep 2017 16:23:49 GMT

What is wrong?

upaliwije — Thu, 21 Sep 2017 16:52:27 GMT

% incorrectly shown totaling not adding upto 100%

sunny_talwar — Thu, 21 Sep 2017 16:55:08 GMT

Which ones? can you point out?

upaliwije — Thu, 21 Sep 2017 16:59:40 GMT

Total Row Should be 100% and respective % should be shown against each reason

sunny_talwar — Thu, 21 Sep 2017 17:02:45 GMT

May be you need this

if(RENEWED_PREMIUM=0 or (RENEWED_REFUNDS*1)=RENEWED_PREMIUM,SUM( RENEWABLE_PREMIUM))

/if(RENEWED_PREMIUM=0 or (RENEWED_REFUNDS*1)=RENEWED_PREMIUM,SUM(TOTAL<DEPT> RENEWABLE_PREMIUM))

upaliwije — Thu, 21 Sep 2017 17:13:26 GMT

Thanks Sunny

It is till not working. This is what I want

sunny_talwar — Thu, 21 Sep 2017 17:18:07 GMT

May be this

Sum(if(RENEWED_PREMIUM = 0 or (RENEWED_REFUNDS*1) = RENEWED_PREMIUM, RENEWABLE_PREMIUM))

/Sum(TOTAL<DEPT> if(RENEWED_PREMIUM = 0 or (RENEWED_REFUNDS*1) = RENEWED_PREMIUM, RENEWABLE_PREMIUM))

upaliwije — Thu, 21 Sep 2017 17:24:24 GMT

Thanks Sunny

This is exactly what I want