Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
New Contributor III

sort by expression in pivot with multiple dimensions

I have 2 Dimensions :

First Dimension, I used : aggr(Count([Score]),[Dimension1]) sort Descending and it is working fine.

However, the Second Dimension: aggr(Count([Score]),[Dimension2]) sort Descending is not behaving like the first.

I got this result:

Dimension 1

Dimension 2

                                    Count( Score)

Program                            200                       

    Entrepreneur                  88

    Business                        90

    Shop                              70

Business                          180

    Gas                                99 

    Garments                        90

      Metal                            98 

ABC                                  150

    Special                            50

      Regular                        80

Expected Result:

                                  Count( Score)

Program                          200

     Business                      90

    Entrepreneur                88

    Shop                            70

Business                        180

    Gas                              99

    Metal                            98

    Garments                    90

ABC                                150

  Regular                         80

    Special                        50

Please help with the correct expression. Thank you!

1 Reply

Re: sort by expression in pivot with multiple dimensions

Hi Isabel,

please refer below thread.

Qliksense Pivot table sorting issue | Qlik Community


Arvind Patil