https://community.qlik.com/t5/App-Development/Sales-amp-Geo-hierarchy/m-p/1583295#M42644 <P>Hi,</P><P>I have attached sample data of Hierarchy</P><P>&nbsp;</P><P>In output need while selecting a date .. sales hierarchy should reflect upto that date.. &amp; city mapping also look accordingly.</P><P>selection will be date</P><P>table column require:</P><P>Reportee name , employee name (EMP), city</P><P>&nbsp;</P><P>Member sheet cease date is termination date of employee</P><P>Memrelation sheet cease date is termination date of employee relation to manager</P><P>Unitrelation sheet cease date is termination date of city/geography</P> Wed, 22 May 2019 11:39:16 GMT QlikAngel 2019-05-22T11:39:16Z https://community.qlik.com/t5/App-Development/Sales-amp-Geo-hierarchy/m-p/1583295#M42644 <P>Hi,</P><P>I have attached sample data of Hierarchy</P><P>&nbsp;</P><P>In output need while selecting a date .. sales hierarchy should reflect upto that date.. &amp; city mapping also look accordingly.</P><P>selection will be date</P><P>table column require:</P><P>Reportee name , employee name (EMP), city</P><P>&nbsp;</P><P>Member sheet cease date is termination date of employee</P><P>Memrelation sheet cease date is termination date of employee relation to manager</P><P>Unitrelation sheet cease date is termination date of city/geography</P> Wed, 22 May 2019 11:39:16 GMT https://community.qlik.com/t5/App-Development/Sales-amp-Geo-hierarchy/m-p/1583295#M42644 QlikAngel 2019-05-22T11:39:16Z