Totals not appearing in Pivot chart for the "variance" expression

[#1]

Hello Qlik Community,

I'm quite new to Qlikview, and I would really appreciate some help on my issue. I've created a Pivot Table, with the Dimensions:

- Subscriber

- Market Segment

- Year

- Quarter/Year

And the Expressions:

- Total Subscribers: = SUM(SUBSCRIBERS)

- Variance: =(SUM(SUBSCRIBERS) / Before(SUM(SUBSCRIBERS))) - 1

My problem is, that when I try to display totals for the Variance expression, I get NULL. Sub-totals seem to be working fine, it's just the Totals that can't be calculated. I've tried a number of syntax, but I can't seem to get it right. Can anyone please point me into the right direction with this one?

I'm attaching a sample of the QV model as well as the total columns which are blank.

Thanks.

[sunny_talwar]

I guess the question is what are the expected number you hope to see there?

[#3]

Hi Sunny,

I'm expecting to see the Total of the variances across, just like the Total for "No of Subscribers" is appearing. For example, the calculated value for the Actor "365", Segment "Mobile Subs", Year "2015" would be:

1.97 + 1.94 + 1.27

Cheers,

[sunny_talwar · Accepted solution]

Can you try this expression:

=Sum(Aggr((SUM(SUBSCRIBERS) / Above(SUM(SUBSCRIBERS))) - 1, ACTOR, SEGMENT, YEAR, QuarterYear))

[#5]

Hi Sunny,

Works perfectly Thanks a million!