Solved: New column to calculate variance between month - Qlik Community

Report Inappropriate Content · ‎2015-10-15

Hi,

I have the following table with the first 2 columns in Qlikview:

The third column is what I want to produce in Qlikview, but cant work out how.

Any advice?

Note, that the Discharge month is a cyclic group.

Thank you.

sunny_talwar · ‎2015-10-15

May be use this expression:

=YourExpressionForElectiveNumber - Above(YourExpressionForElectiveNumber)

sunny_talwar · ‎2015-10-15

May be use this expression:

=YourExpressionForElectiveNumber - Above(YourExpressionForElectiveNumber)

Report Inappropriate Content · ‎2015-10-16

Thank you!

Worked line a treat

sunny_talwar · ‎2015-10-16

Awesome

I am glad it worked the way you wanted.

Best,

Sunny

Report Inappropriate Content · ‎2015-10-16

Ah, have problem......

When I expand on the pivot table, I get the following:

For Sep 15 and Division 1, I need the variance between Aug 15 and Division 1.

Any ideas?