Hello Qlik_sters I have a table with around 1.5M records the table has ProjectNumber, and ParentProjectNumber (can be null in case the project doesn't have a parent) when I use the hierarchy function to get the names hierarchy the total number of rows becomes around 2.3M
in which cases the hierarchy function increases the rows of the table?