topic Re: Inserting a calculated expression into a pivot chart in QlikView

Inserting a calculated expression into a pivot chart

Thu, 29 May 2014 10:43:09 GMT

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

Re: Inserting a calculated expression into a pivot chart

Thu, 29 May 2014 10:49:13 GMT

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.

Re: Inserting a calculated expression into a pivot chart

Thu, 29 May 2014 10:52:58 GMT

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)

Re: Inserting a calculated expression into a pivot chart

Thu, 29 May 2014 12:03:42 GMT

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

Re: Inserting a calculated expression into a pivot chart

Thu, 29 May 2014 12:58:22 GMT

Check the field names are correct as Qlikview is case sensitive