topic Re: Pivot table dimension expression columns totals in QlikView

Pivot table dimension expression columns totals

sunilkumarqv — Sat, 29 Nov 2014 07:00:04 GMT

Hi all ,

can bring partial sum for dimension expression for pivot table i have total four dimensions with in that two expression and one expression i have tried to do with could any one help out of this please.

Re: Pivot table dimension expression columns totals

arulsettu — Sat, 29 Nov 2014 07:13:30 GMT

have you tried this

Re: Pivot table dimension expression columns totals

sunilkumarqv — Sat, 29 Nov 2014 07:25:54 GMT

it wont work in my case the dimension which have used with aggr functions is there anything which we can do in that expression .

Re: Pivot table dimension expression columns totals

arulsettu — Sat, 29 Nov 2014 07:42:30 GMT

can you post your expression

Re: Pivot table dimension expression columns totals

sunilkumarqv — Sat, 29 Nov 2014 08:10:18 GMT

My expression

aggr(sum({<feil={'1'},Month=>}),Dimension1,Dimension2)

Re: Pivot table dimension expression columns totals

arulsettu — Sat, 29 Nov 2014 08:20:22 GMT

here we need a advance aggregation

try like this

=sum(aggr(sum({<feil={'1'},Month=>}),Dimension1,Dimension2))