topic Re: Cumulative sum in tree in QlikView

Cumulative sum in tree

Tue, 14 Jan 2014 20:03:56 GMT

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!

whiteline — Tue, 14 Jan 2014 20:10:27 GMT

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.

Wed, 15 Jan 2014 10:09:47 GMT

Hi,

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

whiteline — Wed, 15 Jan 2014 21:00:35 GMT

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 ?

Thu, 16 Jan 2014 11:30:03 GMT

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:

Thu, 16 Jan 2014 17:32:01 GMT

see this link the solution;