topic Reduce hierarchy by fact table in QlikView https://community.qlik.com/t5/QlikView/Reduce-hierarchy-by-fact-table/m-p/210756#M65210 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i´ve got an hierarchy and a fact table. There are only facts for the lowest hierarchy level. And now, i want to show the hierarchy paths just for those who have facts.</P><P>It´s not a problem creating the hierarchy, but when i use join or exists for reducing, the hierarchy is destroyed and as a result, i just see the lowest level of it.</P><P>I´ve attached an example. Only John and Mary have sales. And because of that, the hierarchy should be reduced to themselves and their parentnodes, like this:</P><P>George</P><P>Frank</P><P>John</P><P>Mary</P><P></P><P>Has anyone an idea how to do this?</P><P></P><P></P><P></P></BODY></HTML> Thu, 10 Feb 2011 15:44:29 GMT 2011-02-10T15:44:29Z Reduce hierarchy by fact table https://community.qlik.com/t5/QlikView/Reduce-hierarchy-by-fact-table/m-p/210756#M65210 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i´ve got an hierarchy and a fact table. There are only facts for the lowest hierarchy level. And now, i want to show the hierarchy paths just for those who have facts.</P><P>It´s not a problem creating the hierarchy, but when i use join or exists for reducing, the hierarchy is destroyed and as a result, i just see the lowest level of it.</P><P>I´ve attached an example. Only John and Mary have sales. And because of that, the hierarchy should be reduced to themselves and their parentnodes, like this:</P><P>George</P><P>Frank</P><P>John</P><P>Mary</P><P></P><P>Has anyone an idea how to do this?</P><P></P><P></P><P></P></BODY></HTML> Thu, 10 Feb 2011 15:44:29 GMT https://community.qlik.com/t5/QlikView/Reduce-hierarchy-by-fact-table/m-p/210756#M65210 2011-02-10T15:44:29Z AW:Reduce hierarchy by fact table https://community.qlik.com/t5/QlikView/Reduce-hierarchy-by-fact-table/m-p/210757#M65211 <HTML><HEAD></HEAD><BODY><P>Nobody?</P></BODY></HTML> Fri, 11 Feb 2011 13:32:32 GMT https://community.qlik.com/t5/QlikView/Reduce-hierarchy-by-fact-table/m-p/210757#M65211 2011-02-11T13:32:32Z