topic Re: Incorrect total for a percent column in QlikView

Incorrect total for a percent column

Fri, 22 Feb 2013 05:08:41 GMT

Hi,

Please look at the attached qvw where I am not getting the right value in the total of last column after I select the "show non zero budget". The total variance % remains the same regardless of whether the list box is selected or not.

I am using "Expression Total" for the % column and Sum of rows for all others.

Thanks.

Re: Incorrect total for a percent column

sushil353 — Fri, 22 Feb 2013 05:12:23 GMT

PFA

Re: Incorrect total for a percent column

Fri, 22 Feb 2013 05:15:42 GMT

-137% is not the right answer. The correct Variance % = (-100)/525 = -19%

Re: Incorrect total for a percent column

sujeetsingh — Fri, 22 Feb 2013 05:46:48 GMT

Mayank actually it is due to expression sum of rows.

Re: Incorrect total for a percent column

phaneendra_kunc — Fri, 22 Feb 2013 06:52:12 GMT

See if the attached helps...

Usually even though if you have enabled the SUM for the expression total...because of oyur IF statement in the ACTUAL expression total column will consider only sum(Actual) and it never evaluates the concept of where Budget is greater than zero.

Variance % =if(Dimensionality()>0, [Variance]/[BudgetExpr] , (if(GetSelectedCount(ShowClients)>0, sum({<Budget-={0}>}Actual), sum(Actual)) - [BudgetExpr])/[BudgetExpr])