0 Replies Latest reply: Apr 8, 2014 4:02 AM by Luca Rizziero RSS

    order by expression in the 4th dimension of a pivot table

    Luca Rizziero

      Hi,

       

      I have a pivot table [full pivot] with 7 dimensions and 2 expressions  ([quantity] and [Total by Cust.]).

      I need to order the first 3 dimensions by the text string, while the fourth (customer) being ordered by an ABC analisys of the quantity.

      Even if I'm able to represent correctly the [Total by Cust.] column (expression #2), QlikView seems not consider it in the right way when being usend as an order expression.

       

      Thanks in advance.

       

      Luca