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: 
amien
Specialist
Specialist

hierarchy question, using expression to sum up all the level - rollup

i have a material hierarchy which is all loaded into one table. Its from bottom to top.

Pathname is like this .../...../.....

All normal..

But now i want to load another table which links to the hierarchy table. This new table contains to columns. MaterialID (for linking to the hierarchy table) and a column which contains # of days to produce.

now i pu this in my expression : SUM(Days)

this all works fine, but when i 'roll-up' the total days are not calculated. When i roll-up to the highest level. I will see the number of days of the highest level. It doesn't to a sum of all the days that are also on a lower level.

how can i fixed this

11 Replies
amien
Specialist
Specialist
Author

i will going to try with an unique key . but i thought that pathname by itself was allready unique.

I need to make a new key and can't use material number, because the same material number can be used in a different superior material

hdonald
Creator
Creator

Ok, if you stick with Material Name you could try adding the NODISTINCT qualifier to the aggr...

e.g. aggr(NODISTINCT sum..

Regards,

HD