https://community.qlik.com/t5/App-Development/aggr-sort-with-hierarchy/m-p/1750560#M57755 <P>Hello!</P><P>I have a chart that contains rangesum and above for the past 7 days, from my date basis sorted table.</P><P>Because of that, on default Qlik Sense does not allow me to sort that table, I found the solution in these forums by using aggr's sort function while using rangesum and above,</P><P>however I am using a hierachy so its dynamic, is there anyway to write the expression with hierachy?</P><P>Revenue is my measure column and Marketing is the name of my hierarchy.</P><P><BR />Thank you a lot!</P><P>&nbsp;</P> Thu, 08 Oct 2020 07:03:36 GMT DropTable 2020-10-08T07:03:36Z https://community.qlik.com/t5/App-Development/aggr-sort-with-hierarchy/m-p/1750560#M57755 <P>Hello!</P><P>I have a chart that contains rangesum and above for the past 7 days, from my date basis sorted table.</P><P>Because of that, on default Qlik Sense does not allow me to sort that table, I found the solution in these forums by using aggr's sort function while using rangesum and above,</P><P>however I am using a hierachy so its dynamic, is there anyway to write the expression with hierachy?</P><P>Revenue is my measure column and Marketing is the name of my hierarchy.</P><P><BR />Thank you a lot!</P><P>&nbsp;</P> Thu, 08 Oct 2020 07:03:36 GMT https://community.qlik.com/t5/App-Development/aggr-sort-with-hierarchy/m-p/1750560#M57755 DropTable 2020-10-08T07:03:36Z