Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Qlik Sense how to disable sort feature on straight table ?

Hi All

May i know how to prevent user from click on the table first row field to sort ?

My this table if some one click the sort by sales  or Opportunity or Assigned to field , the table will display the wrong result.

Paul

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I don't think there is a setting to turn off interactive sort, but there is a bit of a trick you can apply.  If you use any of the inter-row functions -- such as Above(), interactive sorting in a table is disabled.  So wrap one of your measures in Above() with an offset of 0.  For example, assume your Measure is "sum(Sales)".  Change this to:

Above(Sum(Sales),0)

You will get the same results but interactive sort will be disabled.  This will mess with the total values though so you may have to change the total mode to Sum.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

View solution in original post

5 Replies
Digvijay_Singh

You may need to disable interactive sort in below sort view -

Capture.PNG

paulyeo11
Master
Master
Author

Hi Dig

I refer to Qlik Sense , you send me the one is for Qlik View

Paul

Digvijay_Singh

My bad! I think not possible in Qlik Sense.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I don't think there is a setting to turn off interactive sort, but there is a bit of a trick you can apply.  If you use any of the inter-row functions -- such as Above(), interactive sorting in a table is disabled.  So wrap one of your measures in Above() with an offset of 0.  For example, assume your Measure is "sum(Sales)".  Change this to:

Above(Sum(Sales),0)

You will get the same results but interactive sort will be disabled.  This will mess with the total values though so you may have to change the total mode to Sum.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

bmenicucci
Creator
Creator

Hello Rob,

thanks for sharing this; however, for what I've seen it doesn't prevent users from messing up the table sorting on a dimension column. Is there a way, for what you know, to completely disable sorting in straight tables?

Thanks and keep up whit your awesome work here!

Brunello