Problem with aggr()

Wed, 11 Nov 2009 17:44:10 GMT

Hi,

In the Pivot table, I have the expossre of activities into different part (any number betweeb 0 to 1).

my expression is: =sum(Exposure_Weight)

It works perfectly fine. But when I try to reweight them by the partial total of expsoure, using:

sum({$<Type_Sub={"*"}-{[Others]}>}Exposure_Weight)*(100-Rest)/aggr(sum({$<Type_Sub={"*"}-{[Other]}>}Exposure_Weight),Year,Month)

I can get the partial total figures correst. But there is one reweighting figures shown on the table after Type_Sub and other rows just shown "-". If I click to different Type_Sub, there correct figure is back and only for that one.

Is there anything wrong?

Many thanks,

Ivan

Problem with aggr()

Wed, 11 Nov 2009 18:55:47 GMT

I have solved it by using Total<> instead of aggr().

Problem with aggr()

Wed, 11 Nov 2009 19:23:48 GMT

Another way: Still use aggr, but this this , add nodistinct

topic Problem with aggr() in QlikView

Problem with aggr()

Problem with aggr()

Problem with aggr()