Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Inserting a calculated expression into a pivot chart


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

4 Replies
Not applicable
Author

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.

Not applicable
Author

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)

Not applicable
Author

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

Not applicable
Author

Check the field names are correct as Qlikview is case sensitive