topic Re: Subtotal nedded on a separate line in QlikView

Subtotal nedded on a separate line

Sat, 20 Oct 2012 20:22:46 GMT

I would need to calculate a subtotal in one line, without having to insert a partial sum from the Properties/Presentation line.

I attached a picture with the columns I need to calculate a subtotal for, after that I would need a Partial sum, that ommits the calculated subtotal.

Please also find attached the QV file too.

Thank you,

Nandor

Re: Subtotal nedded on a separate line

whiteline — Mon, 22 Oct 2012 19:56:08 GMT

Hi.

Group your Activity types properly (for example create another field) and you'll have two subtotals.

Re: Subtotal nedded on a separate line

Mon, 22 Oct 2012 20:56:33 GMT

I though about that but it would have been more elegant not to introduce an another column.

Thanks for the suggestion.

Re: Subtotal nedded on a separate line

whiteline — Tue, 23 Oct 2012 16:02:44 GMT

There is no need to create another column.

You could use something like this:

[Activity type], [Activity types with subtotals]

Dans, Dans

Înot, Înot

Mic dejun, Mic dejun

Prânz, Prânz

Șah, Șah

Dans, Subtotal1

Înot, Subtotal1

Mic dejun, Subtotal1

Prânz, Subtotal1

Șah, Subtotal1

Plată servicii, Plată servicii

Rata lunară, Rata lunară

Plată servicii, Subtotal2

Rata lunară, Subtotal2

Then you could replace [Activity types] with [Activity types with subtotals] in your table.

Re: Subtotal nedded on a separate line

Wed, 24 Oct 2012 08:31:23 GMT

A simple and perfect solution, thank you.

Re: Subtotal nedded on a separate line

Mon, 29 Oct 2012 17:14:36 GMT

Hi,

Can you atleast show the exact script? I also need this function. I got confused.

Re: Subtotal nedded on a separate line

jagan — Fri, 02 Nov 2012 11:27:20 GMT

Hi,

PFA.

Regards,

jagan.