Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Got it solution by below code.
=If([Dept Group] ='C' and Dimensionality() = 1, Sum(total <Product> Value) ,Sum (Value))
Hi,
it's very simple in Qlik.
Take Pivot table --> Dimensions--> Dept Group ,Product,Dept Name.
Thanks,
Mukram.
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
Hi Mohammed, Please go through the formula once in sample report. Its not just direct 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.
!Hi
Do you want like this because if we enable partial sum then it will display partial sum o C as well
Thanks
No Ritesh, exactly i need it as sample report.
Got it solution by below code.
=If([Dept Group] ='C' and Dimensionality() = 1, Sum(total <Product> Value) ,Sum (Value))