Discussion board where members can get started with QlikView.
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.
Go to Solution.
There is no need to create another column.
You could use something like this:
[Activity type], [Activity types with subtotals]
Mic dejun, Mic dejun
Mic dejun, 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.
Group your Activity types properly (for example create another field) and you'll have two subtotals.
I though about that but it would have been more elegant not to introduce an another column.
Thanks for the suggestion.
A simple and perfect solution, thank you.
Can you atleast show the exact script? I also need this function. I got confused.