1 Reply Latest reply: May 4, 2017 11:03 AM by Handry Orozco RSS

    How is it possible to sort different dimensions in a pivot table based on 1 expression?

    Ignace Devreese

      Dear,

      How is it possible to sort different dimensions in a pivot table based on 1 expression?

      If I sort it via the sort tab in Qlik Sense, and I choose to sort on expression, then the lower dimensions are not sorted themselves, but they follow the sorting of the highest dimension (I need sort them on the same expression).

      Now Qlik Sense gives me the following output:

       

      Category: item nr:      Measure:

      A               item 3           300

                       item 1           200

                       item 2           100

      B               item 3            10

                       item 1            20

                       item 2            30

      C               item 3             2

                       item 1             1

                       item 2             3

       

       

      Actually I need the following output:

      Category: item nr:       Measure:

      A               item 3           300

                       item 1           200

                       item 2           100

      B               item 2            30

                       item 1            20

                       item 3            10

      C              item 2              3

                       item 3               2

                       item 1               1

       

      How can I solve this issue?

       

      Thanks in advance.

       

      Kind regards,

      Ignace Devreese