topic Re: Totals in table in QlikView

Totals in table

Wed, 25 Nov 2020 16:16:04 GMT

Hi There,

I'm trying to create a table/chart in QlikView to reflect the same characteristics as seen below.

How do I show the totals as seen in the picture below?

Thanks,

Re: Totals in table

Colin-Albert — Wed, 27 Jul 2016 14:19:20 GMT

Create a Pivot Table Chart, with Date and S as dimensions and sum(x) as the expression.

On the Presentation Tab, enable partial sums for the Date and S dimensions.

Re: Totals in table

beck_bakytbek — Wed, 27 Jul 2016 14:38:12 GMT

Hi Mike,

i hope that helps

beck

Re: Totals in table

trdandamudi — Wed, 27 Jul 2016 14:40:39 GMT

Please see the attached and modify according to your needs. Hope this helps...

Re: Totals in table

Anonymous — Wed, 27 Jul 2016 14:46:00 GMT

Pivot table is the right answer for you.

Re: Totals in table

Wed, 27 Jul 2016 15:04:11 GMT

Thanks Colin,

I have created the pivot table as seen below. The S1, S2 etc in the previous sample table represent a location. The values seen in the table is a set analysis which calculates a particular measure. The Dimensions as you can see is MonthYear and S. However, I've manually moved S to horizontal position as this is what the end-user requires.

The only issue is that the options on the presentation tab you are suggesting is not available. I would have at least expected the 'Subtotals at Bottom' to work but this resulted in the table as seen in the table below. I do however get the totals at the bottom if the chart is a straight table but the format of the straight table is definitely what I do NOT want.

Re: Totals in table

Wed, 27 Jul 2016 15:25:43 GMT

Perfect!

Thanks to all who contributed.

Re: Totals in table

Colin-Albert — Wed, 27 Jul 2016 15:58:24 GMT

Have you selected "Show Partial Sums" for the dimensions you wish to total?