Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
felcar2013
Partner - Creator III
Partner - Creator III

pivot display partial column sum in the middle of table

Hi

i wanted to know how to get partial sums of a Dimension (WeekDate) displayed after a second Dimension (Year Calender Week). The Expression is a sum(customer)

for ex. from the Chart the partial sum of Week Date shall be : 100+ 94+97= 291 (values only for days of the corresponding week). This value shall appear after the field ; 08-09-13, which is the last day of the week 2013-36 ( and not at the end of the table)

thanks

pivot.png

1 Solution

Accepted Solutions
Not applicable

Hi Felipe have you looked at the partial sums option in the presentation tab of the chart properties?


Untitled.png

Select your dimension, then check "show partial sums"

does this work for you?

Erica

View solution in original post

2 Replies
Not applicable

Hi Felipe have you looked at the partial sums option in the presentation tab of the chart properties?


Untitled.png

Select your dimension, then check "show partial sums"

does this work for you?

Erica

felcar2013
Partner - Creator III
Partner - Creator III
Author

thanks Erika, i.... thought i checked it 🙂