topic Re: Pivot Table Totals not updating with expression that includes variable in QlikView

Pivot Table Totals not updating with expression that includes variable

aliyoung92 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all

I've got a pivot table with an expression (below) that includes a variable linked to a slider.

So when I increase/decrease the variable in the slider it then changes the value in my pivot for the respective line in the pivot table. This works perfectly, however the Totals (partial sums) do not update with the change in variable.

Any help appreciated.

Thanks

=IF(%Identifier=1,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%1/100,

IF(%Identifier=2,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%2/100,

IF(%Identifier=3,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%3/100,

IF(%Identifier=4,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%4/100,

IF(%Identifier=5,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%5/100,

IF(%Identifier=6,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%6/100,

IF(%Identifier=7,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%7/100,

sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers))))))))

Re: Pivot Table Totals not updating with expression that includes variable

sunny_talwar — Wed, 27 Jun 2018 11:06:53 GMT

What are you chart dimensions? May be try this

Sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}Aggr(

IF(%Identifier=1,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%1/100,

IF(%Identifier=2,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%2/100,

IF(%Identifier=3,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%3/100,

IF(%Identifier=4,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%4/100,

IF(%Identifier=5,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%5/100,

IF(%Identifier=6,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%6/100,

IF(%Identifier=7,sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers) + sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers)*vIncrease%7/100,

sum({<QVversion = {'Scenario1'},CollegeCode={'DCD'}>}StudentNumbers))))))))

,ChartDimensionsHere))

Re: Pivot Table Totals not updating with expression that includes variable

aliyoung92 — Wed, 27 Jun 2018 11:29:48 GMT

That's brilliant, thanks for your help.