Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Subtotal nedded on a separate line

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

1 Solution

Accepted Solutions
whiteline
Honored Contributor II

Re: Subtotal nedded on a separate line

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.

6 Replies
whiteline
Honored Contributor II

Re: Subtotal nedded on a separate line

Hi.

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

Not applicable

Re: Subtotal nedded on a separate line

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

Thanks for the suggestion.

whiteline
Honored Contributor II

Re: Subtotal nedded on a separate line

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.

Not applicable

Re: Subtotal nedded on a separate line

A simple and perfect solution, thank you.

Not applicable

Re: Subtotal nedded on a separate line

Hi,

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

MVP & Luminary
MVP & Luminary

Re: Subtotal nedded on a separate line

Hi,

PFA.

Regards,

jagan.

Community Browser