topic Re: Pivot table - Partial sums in QlikView

Pivot table - Customized Partial sums

nihhalmca — Wed, 25 Nov 2020 16:16:04 GMT

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

mdmukramali — Wed, 05 Sep 2018 06:19:11 GMT

Hi,

it's very simple in Qlik.

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

Thanks,

Mukram.

Anonymous — Wed, 05 Sep 2018 09:29:28 GMT

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 — Wed, 05 Sep 2018 12:41:48 GMT

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

nihhalmca — Wed, 05 Sep 2018 12:44:38 GMT

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 — Wed, 05 Sep 2018 13:28:10 GMT

!Hi

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

Thanks

nihhalmca — Fri, 07 Sep 2018 07:24:01 GMT

No Ritesh, exactly i need it as sample report.

nihhalmca — Fri, 07 Sep 2018 07:45:14 GMT

Got it solution by below code.

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