Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
nihhalmca
Valued Contributor 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
Valued Contributor II

Re: Pivot table - Customized Partial sums

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
Valued Contributor III

Re: Pivot table - Partial sums

Hi,

it's very simple in Qlik.

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

313011.PNG

Thanks,

Mukram.

ritesh_kodolikar
Contributor

Re: Pivot table - Partial sums

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
Valued Contributor II

Re: Pivot table - Partial sums

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

nihhalmca
Valued Contributor II

Re: Pivot table - Partial sums

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.

ritesh_kodolikar
Contributor

Re: Pivot table - Partial sums

!Hi

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

Thanks

nihhalmca
Valued Contributor II

Re: Pivot table - Customized Partial sums

No Ritesh, exactly i need it as sample report.

nihhalmca
Valued Contributor II

Re: Pivot table - Customized Partial sums

Got it solution by below code.

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

View solution in original post