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: 
aliyoung92
Contributor III
Contributor III

Pivot Table Totals not updating with expression that includes variable

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))))))))

1 Solution

Accepted Solutions
sunny_talwar

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))

View solution in original post

2 Replies
sunny_talwar

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))

aliyoung92
Contributor III
Contributor III
Author

That's brilliant, thanks for your help.