I have a requirement to incorporate hierarchy based on time interval in qlikview.
The scenario is to build sales hierarchy with contains from and to date. I have successfully used hierarchy function to create parent and child nodes but due to date intervals, the result is messed up. The approach i followed is to use interval match to link hierarchy with FACT.
