topic sum without 1 dimension in QlikView

sum without 1 dimension

Anonymous — Mon, 02 Mar 2015 13:24:38 GMT

hi,

i have pivot table & i want in one expresion to calcult with one of the daimension .

how to write it ?

thanks'

yarin.

sunny_talwar — Mon, 02 Mar 2015 13:26:58 GMT

Not sure what you are trying to do. Can you elaborate a little and a sample would be very helpful.

Best,

anbu1984 — Mon, 02 Mar 2015 13:34:35 GMT

For ex Dim are Dim1,Dim2

If you want to write expr without Dim2, then use Aggr(Sum(Field),Dim1)

Anonymous — Mon, 02 Mar 2015 13:35:28 GMT

i can't upload sample i'll .

in the pivot i have dimension with "cage_num" and "profile".

i mark the feild for this dimansion(cage_num) as "supress when vale is null",

when i do this i cant see the "kg" for the profile becuse he is realy don't have "cage_num".

is it posiblle in set analys to do sum(kg) with ignore the "cage_num" ?

sunny_talwar — Mon, 02 Mar 2015 13:38:30 GMT

May be you are looking for something like this to ignore cage_num:

=Aggr(Sum(kg), profile)

HTH

Best,

morganaaron — Mon, 02 Mar 2015 13:39:36 GMT

You could just use a total over the dimension you don't want? E.g. Sum(Total <Dim1> Sales).