Inserting a calculated expression into a pivot chart

[#1]

Hi i need help with something that i feel should be quite simple.  I am trying to compare data for 2 different years comparing current year and prior year budgets against a list of subjective codes.  My budgets are within a field called 'Type' and they are names 'Bud 2013-14' and 'Bud 2014-15' within it.  The subjective field is simply called 'Subjective'.

I know you can insert calculating items into a pivot table so i assumed it must be straighforward to do it on Qlikview.

Any help would be greatly appreciated.

Regards

Richard

[#2]

You can use Set Analysis here for comparison.

In one expression you can use something like below,

exp1: Sum({$<Type='Bud 2013-14'>} budget)

exp2: Sum({$<Type='Bud 2014-15'>} budget)

Dimension: Subjective

Thanks,

Mani.

[#3]

Set your dimension as "Subjective"

Goto the expressions tab and create 2 expressions

LastYear: Sum({$<Type={'Bud 2013-14'}>} budget)

CurrentYear: Sum({$<Type={'Bud 2014-15'}>} budget)

[#4]

Thanks very much.  I have done what you have said and it is insering two columns into my pivot chart but unfortunately they have a nil value

[#5]

Check the field names are correct as Qlikview is case sensitive