Documents for QlikView related information.
I prepare sample to show how can rollup node's amount in hierarchy
to do this we need two hierarchy:
one of them hierarchy with CountryName:
and another one hierarchy with code
and at the last we need For loop to assign SalesAmount to each Parent:
FOR each i in 17,13,9,5,1
Mid(CountryHierarchy2,$(i),3) as ChildNodeCode,
sum(SalesAmount) as Sum_LowerLever_SalesAmount
Group by Mid(CountryHierarchy2,$(i),3);
in attached file you can find the sample qvw file
Thanks for you contribution!