Sum of all dimensions

[#1]

Hi All,

I need some of all dimension to calculate share. it calulated properly but only showing for 2 or less rows. file is attached.

[Gysbert_Wassenaar]

See attached qvw. Are that the kind of shares you're looking for?

[#3]

Thanks for reply..

but if you notice qlikview has value21.4% for 1 and 2 month which not correct.

(sum of all partner in relevant month)

[#4]

Hi!

Maybe you can use:

if(sum(TotalCost)/aggr(sum({<Partner=>}TotalCost),Month),aggr(sum({<Partner=>}TotalCost),Month),0)

or

if(sum(TotalCost)/aggr(sum({<Partner=>}TotalCost),Month),aggr(sum({<Partner=>}TotalCost),Month),sum(TotalCost))

There is no division by 0.

By

Rebeca

[#5]

Hi Rebeca,

thanks for help.. sum exist for all actualy.

Regards

Altaf