topic New subtotal in QlikView

New subtotal

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I need to create two new rows "total" in the positions that I have indicated in the figure. The table is a table pivots.

The totals must be calculated in the following way:

Total (101,102): 1500+2590 = 4090

Total (201,202,203): 850+450+800 = 2100

How can I do?

Thanks!

Re: New subtotal

sundarakumar — Sat, 21 Jun 2014 12:20:34 GMT

U can do it if 101 and 102 belong to another hierarchy like 100 and 201,202,203 belongs to the 200 in the same level. I mean if u have data as below.

100 101

102

200 201

202

203

If u don't have hierarchy as shown try to create one with some business logics, since u look interested in summing 101,102 and 201,202,203. If u don't have such level then I thinks its hard.

Once u have that level created u have the option in presentation tab. otherwise I guess it is not possible in Pivot table.

Regards,

Sundar

Re: New subtotal

Anonymous — Sat, 21 Jun 2014 12:52:30 GMT

Hello, Marco

You can use a calculated dimension with a expression like

=Floor(cdc, 100)

=Left(cdc, 1)

Put one of those expressions as your first dimension and turn on subtotals for it.

Hope it helps.

Re: New subtotal

Mon, 23 Jun 2014 13:27:39 GMT

Thank you! It works!

Is possibile to change value in red circles in other value?

Example:

100 -> First

200 -> Second

300 -> Third

...

Thanks!

...

Re: New subtotal

Anonymous — Tue, 24 Jun 2014 01:51:43 GMT

Hi.

Try this one:

=Pick(Left(cdc, 1), 'First', 'Second', 'Third', 'Fourth', 'Fifth', 'Sixth', 'Seventh', 'Eighth', 'Ninth')