Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Partial sum in Pivot tables



Hi all

I have the following Pivot table and want to have a partial sum on the expressions MTD, øQT-1 and FY by Client_Status.

As the expressions a build with long if-statements the partial sum doesn't work. If I only put in a simple
sum (Attribute) statement for them it works.

Can anybody tell me how to get it working?

Many thanks in advance

Melanie



MTDMTDMTDMTDøQT-1øQT-1øQT-1øQT-1FYFYFYFY
StausCENTotalCENTotalCENTotal
IdentFlowSizeTotalTotalTotal
AWFHgroesser5-7,8652,537--3,703426--54,16610,31910,319
AWFHkleiner5-1,935-12,710---227-4,679---5,704-78,199--
AWFHplusminus5-2,012-5,5381,206--482-1,625284--8,387-31,8316,1586,158
POUJgroesser5-0-0-0-0-34-34
POUJkleiner5--40--40--2--2--70--70
POUJplusminus5-0---0----1--
KLJMgroesser5-3,3701,074--2,663463--35,7415,6345,634
KLJMkleiner5-165-4,1180--79-2,9160--1,002-34,363-26-26
KLJMplusminus5-157-729304--92-280214--1,070-3,6532,8192,819


0 Replies