Solved: Cumulative sum in tree - Qlik Community

Report Inappropriate Content · ‎2014-01-14

Hello,

I have this table:

I need this result:

I need in QlikView the same comand SQL, for exemplo select sum(total) from table where FTEC_Arvore like FTEC_Arvore + '*'

Or other solution....

Thanks!

Report Inappropriate Content · ‎2014-01-16

see this link the solution;

whiteline · ‎2014-01-14

Hi.

You can parse the hierarchy FTEC_Arvore in script with SubField function.

Create separate field for each level.

Then you can easily calculate total in pivot table.

Report Inappropriate Content · ‎2014-01-15

Hi,

Yes, it's possible. But i don't want create many column i need 1 column, because the tree grows without limits...

whiteline · ‎2014-01-15

Don't understand the result.

You have many rows and three sets of rows that overlap with each other.

So you can get three values. How the resulting table should look like ?

Report Inappropriate Content · ‎2014-01-16

I need sum the node, for example:

sum the node 12250/20207

sum the node 12250/20207/35426

sum the node 12250/20207/35426/35734

view this link about more informations:

Report Inappropriate Content · ‎2014-01-16

see this link the solution;