Discussion Board for collaboration on QlikView Scripting.
I've been struggling with some logic that will return department number roll-ups to the highest level, in this case the queen bees.
My data is like this...
I need to return data rolled up by Queen like this...
Go to Solution.
You're looking for the Hierarchy function. See this blog post: Unbalanced, n-level hierarchies
PFA the sample app.
Hope this is the requirement...
Thank you Gysbert...will take some time to digest this...am slammed.
Thank you, too Nitin. I applied this logic to my dataset and it didn't turn out as expected. Hope to get back to this but am slammed with other projects.
OK No problem,
But as I understood, the output was same as in you mentioned...
What was the issue???
Hi Nitin, my pseudo dataset may be wrong. I like being told the answer, but to understand the hierarchy function I really need to dig into the documents Gysbert pointed me towards.