topic Ratio with partial sum ? in QlikView

Ratio with partial sum ?

Tue, 01 Mar 2011 19:02:00 GMT

Hello Qlikview community

How can I assume a partial sum in the calculation formula?

I want a output for the column "factor" the ratio of the blue markings / by the partial sum for the months, red flag, etc. ..

Example:

The row "T-Online Business" has a value of € 18,279.24. This value should be divided by the monthly sum of € 67,697.67.
The row "T-Online Lifestyle" has a value of € 20,909.60. This value should be divided by the monthly sum of € 67,697.67.
...

The row "3minutes"" has a value of € 65,014.29. This value should be divided by the monthly sum of € 121,026.00.
and so on...

How can I do this ? Thank you very much !

Best regards,

Ratio with partial sum ?

pover — Tue, 01 Mar 2011 19:16:36 GMT

The formula would be something like the following:

sum(Sales)/sum(total <month> Sales)

The "total <month>" will give you the partial sum for month.

Regards.

Ratio with partial sum ?

Tue, 01 Mar 2011 19:31:45 GMT

Hi Karl,

thank you for your help.

I tried this formula: = sum(conversion)/ sum(total < [HEL_DATA_Datum > MONTH] > conversion)

But it wont work ! Please look at my qvw app that i have attached.

Ratio with partial sum ?

pover — Tue, 01 Mar 2011 19:37:12 GMT

You can't refer to the columns within a sum since QV doesn't allow nested sums so the formula should be:

=conversion
/

money(sum(total <[HEL_DATA_Datum > MONTH]>

Aggr(

if( index(concat([HEL_BANNER_Banner]),'lock')>=1,
(sum([HEL_DATA_Imps mit Defaults])*0.5),(sum([HEL_DATA_Imps mit Defaults])) ) *
SAL_OPPORTUNITYLINEITEM_UnitPrice

,SAL_OPPORTUNITY_Name, SAL_PRODUCT_Name)))

Ratio with partial sum ?

Tue, 01 Mar 2011 19:43:00 GMT

Thank you