Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master II
Master II

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.

View solution in original post

6 Replies
whiteline
Master II
Master II

Hi.

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

Not applicable
Author

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

Thanks for the suggestion.

whiteline
Master II
Master II

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
Author

A simple and perfect solution, thank you.

Not applicable
Author

Hi,

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

jagan
Luminary Alumni
Luminary Alumni

Hi,

PFA.

Regards,

jagan.