Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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.

Highlighted
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