Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you try this expression:
=Sum(Aggr((SUM(SUBSCRIBERS) / Above(SUM(SUBSCRIBERS))) - 1, ACTOR, SEGMENT, YEAR, QuarterYear))
I guess the question is what are the expected number you hope to see there?
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,
Can you try this expression:
=Sum(Aggr((SUM(SUBSCRIBERS) / Above(SUM(SUBSCRIBERS))) - 1, ACTOR, SEGMENT, YEAR, QuarterYear))
Hi Sunny,
Works perfectly Thanks a million!