Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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

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

2 Replies
handry_orozco
New Contributor III

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

Hi

It is imposible, if your pivot table have more one dimension

pyfferooney
New Contributor

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

Is there still no work-around for this problem?