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: 
nihhalmca
Specialist II
Specialist II

Pivot table - Customized Partial sums

Hi All,

I am attaching sample report here which i need to replicate in QlikView/Qlik Sense.

Note: Please make sure that formula at cell '14' in sample report.

Thanks,

Nihhal

1 Solution

Accepted Solutions
nihhalmca
Specialist II
Specialist II
Author

Got it solution by below code.

=If([Dept Group] ='C' and Dimensionality() = 1, Sum(total <Product> Value) ,Sum (Value))

View solution in original post

7 Replies
mdmukramali
Specialist III
Specialist III

Hi,

it's very simple in Qlik.

Take Pivot table --> Dimensions-->  Dept Group ,Product,Dept Name.

313011.PNG

Thanks,

Mukram.

Anonymous
Not applicable

Hi,

In Qlik Tech We can do it

Dimension : DeptGroup

                    DeptName

In Presentation select Dept Name And check Show Partial Sums and Subtotals at bottom

PFA Sample

Thanks

nihhalmca
Specialist II
Specialist II
Author

Hi Mohammed, Please go through the formula once in sample report. Its not just direct partial sums.

nihhalmca
Specialist II
Specialist II
Author

Hi Ritesh, Please go through the formula once in sample report. Its not just direct partial sums.

For instance: As per your snap shot total of depart c1 and c2 should be 245 not 90.

Anonymous
Not applicable

!Hi

Do you want like this because if we enable partial sum then it will display partial sum o C as well

Thanks

nihhalmca
Specialist II
Specialist II
Author

No Ritesh, exactly i need it as sample report.

nihhalmca
Specialist II
Specialist II
Author

Got it solution by below code.

=If([Dept Group] ='C' and Dimensionality() = 1, Sum(total <Product> Value) ,Sum (Value))