topic Re: Automatic aggregation along a hierarchy in QlikView

Automatic aggregation along a hierarchy

Anonymous — Wed, 15 May 2013 14:44:33 GMT

Hello,

I've made a hierarchy in order to see a geographical dimension as a tree. I would like that if a user clicks on a node, he sees the total amount of all the underneath nodes.

In the example attached, if I clik on 'France' in the selection list, it's OK I get the lines for France, but if I clik on 'France' in the tree, I can't see anything.

Is there a solution by using Hierarchy or HierarchyBeslongsTo ?

Thanks in advance

Thierry

Re: Automatic aggregation along a hierarchy

jvitantonio — Wed, 15 May 2013 14:49:51 GMT

If you go to your table and check the data , you'll see that for field Chemin when the value is Portugal, Espagne or France you have no values assign in Pays, so this will select nothing. You either add the country there or you set analysis in your expressions.

Re: Automatic aggregation along a hierarchy

Anonymous — Wed, 15 May 2013 15:23:48 GMT

Do you mean the solution is to calculate in the script the aggregation for the nodes above the lowest nodes ?