10 Replies Latest reply: Jun 10, 2016 1:46 PM by QlikNewbie k RSS

    Sort by expression using one measure and one dimension

    QlikNewbie k

      I am sorting the rows in my table by expression. Right now I'm using one of my dimensions (Say we call is Dimention1) as the expression to sort, but I need to sort rows by another measure (say we call it Measure1), too. Is this possible?

       

      Right now the expression is basically: Dimension1

      If I change it to sum(Measure1), then I lose the sorting by Dimension1. How can I have both?

      Thanks!