Solved: Re: Pivot Set Analysis Sub Total - Qlik Community

Report Inappropriate Content · ‎2014-12-29

Hi,

I have a pivot table with 2 expressions

sum(Value)
aggr(sum({<YearMonth,MATID={'1'}>}Value),$(vReports_Dimensions))

The partial sum is working for the first expression and not for the second!

Any ideas?

Thanks,

FLC

PrashantSangle · ‎2014-12-29

Hi,

Try like

Sum(aggr(sum({<YearMonth,MATID={'1'}>}Value),$(vReports_Dimensions)))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2014-12-29

Hi,

Try like

Sum(aggr(sum({<YearMonth,MATID={'1'}>}Value),$(vReports_Dimensions)))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Report Inappropriate Content · ‎2014-12-29

Perfect!

Thanks Max.