topic Re: Problem with sum calculation in straight table in QlikView

Problem with sum calculation in straight table

venkatg6759 — Fri, 20 Sep 2013 14:49:35 GMT

Hello All,

I have a straight table which gives weights which is a dimension and % bad which is an expression ,weighted% bad another expression.

Weight % bad Weighted &bad Filed

0.5% 0.8% 10% Australia

Weighted %bad =%bad* weights

I want to get the weighted%bad sum for each field .For that i should get weights sum in the dimension.Can anyone help me to fix it.

The result would probably be like this

Weight Sum(%bad) Weighted%bad Field

10% (which is total) 3.5% 35%(which is total)

5% 2 % Austrailia

2% 3% America

Thanks,

Venkat

Fri, 20 Sep 2013 19:03:51 GMT

Attach a qvw would help. Thanks.

Clever_Anjos — Fri, 20 Sep 2013 19:54:57 GMT

Which expression is "%bad* weights "?

Clever_Anjos — Fri, 20 Sep 2013 20:24:34 GMT

So we shoud rewrite your expression using a AGGR function.

Are you familiar with this function?

Clever_Anjos — Fri, 20 Sep 2013 20:32:52 GMT

Is difficult trying to help without your data.

Maybe you could use some "Scramble" (Document Properties/Scrambling) to mix-up sensitive data and post a qvw