# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for
Did you mean:
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
Specialist II
Author

Got it solution by below code.

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

7 Replies
Specialist III

Hi,

it's very simple in Qlik.

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

Thanks,

Mukram.

Creator

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

Specialist II
Author

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

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.

Creator

!Hi

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

Thanks

Specialist II
Author

No Ritesh, exactly i need it as sample report.

Specialist II
Author

Got it solution by below code.

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