New column to calculate variance between month

[#1]

Hi,

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

Discharge   Month_Year	Elective- Number	Variance
Apr-14	1,883
May-14	1,974	91
Jun-14	1,852	-122
Jul-14	1,993	141
Aug-14	1,867	-126

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 · Accepted solution]

May be use this expression:

=YourExpressionForElectiveNumber - Above(YourExpressionForElectiveNumber)

[#3]

Thank you!

Worked line a treat

[sunny_talwar]

Awesome

I am glad it worked the way you wanted.

Best,

Sunny

[#5]

Ah, have problem......

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

AdmissionMonthYY	Adm_Div	Elective - Total	Elective -   Total Variance
Aug-15	Division 1	394	-
Aug-15	Division 2	2	-392
Aug-15	Division 3	275	273
Aug-15	Division 4	129	-146
Aug-15	Division 5	973	844
Aug-15	Division 6	0	-973
Sep-15	Division 1	408	-
Sep-15	Division 2	1	-407
Sep-15	Division 3	304	303
Sep-15	Division 4	173	-131
Sep-15	Division 5	1,182	1009

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

Any ideas?