Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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)
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
Check the field names are correct as Qlikview is case sensitive