Qlik Sense how to disable sort feature on straight table ?

[paulyeo11]

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

[Digvijay_Singh]

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

[paulyeo11]

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 · Accepted solution]

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]

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