Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Running total over Subtotals (multiple dimensionalities)

Hi guys,

I am having some trouble getting a straight table working and the issue seems to be a number of subtotals.

The case is this:

Dimensionality()
RowNo(TOTAL)
RowNo()

Month
Week
Primo BalanceValue InValue outValue2 outDifferenceUltimo Balance
2111110005002002001001100
22212110050001000200020003100
2331331005000300090011002000
144Subtotal Month 1Subtotal Month 11000105004200310032002000
25124200010005001004002400

I cant get the "Primo Balance" and "Ultimo Balance" nor "Difference" working, primarily because of the mixed dimensionality(). The "Primo balance = 1000" is just an inline load that is added to the real transactions as a baseline. The real transactions are the value columns.

i have tried to solve this for the last couple of hours and here are my thoughts:

- So basically the Primo Balance should take an above(UltimoBalance), but since the ultimo balance is calculated using the PrimoBalance column this seemingly creates a loop of some sort and therefore it is not as simple as this?

- I tried using RangeSum (above(sum(Difference),0,RowNo(TOTAL))), but this doesnt work either, and it just starts over after the subtotal

I hope this makes sense to any of you - basically i want the example as above duplicated and right now row 4 and 5 are simply impossible for me to figure out, as is the "difference" but this column is not important, as i just tried using that in order to populate the Balance-columns somehow.. Might be a case of "cant see the woods for all the trees" - i hope so

THANK YOU SO MUCH!

1 Solution

Accepted Solutions
MVP
MVP

Re: Running total over Subtotals (multiple dimensionalities)

This is a pivot table, not a straight table right?

And could you maybe upload some few sample records for the couple of weeks shown?

View solution in original post

2 Replies
MVP
MVP

Re: Running total over Subtotals (multiple dimensionalities)

This is a pivot table, not a straight table right?

And could you maybe upload some few sample records for the couple of weeks shown?

View solution in original post

Not applicable

Re: Running total over Subtotals (multiple dimensionalities)

I managed to fix (HACK!) it in the meantime.. Thx for reading and wanting to help !