topic Re: Qlik Sense how to disable sort feature on straight table ? in App Development

Qlik Sense how to disable sort feature on straight table ?

paulyeo11 — Fri, 23 Feb 2018 02:54:39 GMT

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

Re: Qlik Sense how to disable sort feature on straight table ?

Digvijay_Singh — Fri, 23 Feb 2018 03:09:28 GMT

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

Re: Qlik Sense how to disable sort feature on straight table ?

paulyeo11 — Fri, 23 Feb 2018 03:11:01 GMT

Hi Dig

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

Paul

Re: Qlik Sense how to disable sort feature on straight table ?

Digvijay_Singh — Fri, 23 Feb 2018 03:18:33 GMT

My bad! I think not possible in Qlik Sense.

Re: Qlik Sense how to disable sort feature on straight table ?

rwunderlich — Fri, 23 Feb 2018 03:28:54 GMT

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

Re: Qlik Sense how to disable sort feature on straight table ?

bmenicucci — Thu, 08 Aug 2019 08:17:31 GMT

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