topic Re: AW:Re: Set sort order on simple table box in QlikView

Set sort order on simple table box

Thu, 02 Sep 2010 08:22:56 GMT

Hi,

this sounds extremely simple - and I searched the forum, too. I just cannot believe it ...

1. How can I have a simple table box with a fixed sort order, i.e. the user cannot change the sort order by clicking the table header?

2. How can I use the API to set a specific column to sort order in ascending direction.

myTableBox.SortBy 2 e.g. does not set the asc/desc order. It will depend on how the columns was sorted first.

Answering either 1 or 2 will really help me. Thanks for you support.

Regards,

Georg

Set sort order on simple table box

hopkinsc — Thu, 02 Sep 2010 08:57:47 GMT

Hi, i'm not sure if i understand you correctly, but if you want to stop the user from being able to sort any of the headings all you need to do is untick 'alow interactive sort' from the sort tab.

Set sort order on simple table box

Thu, 02 Sep 2010 09:03:01 GMT

That's what I expected. But there is no!

On the sort tab there is

sort priority / sort by / move up / move down

and that's it!

Best regards,

Georg

AW:Re: Set sort order on simple table box

brenner_martina — Thu, 02 Sep 2010 10:25:22 GMT

Hi,

the solution is: you find 'allow interactive sort' only in a table chart, not in a table box. In a table box it is not possible to 'not allow' interactive sorting.

AW:Re: Set sort order on simple table box

stevedark — Fri, 03 Sep 2010 00:30:34 GMT

Hi there,

Generally I find it is good to avoid table boxes as they are limited in a number of ways. To get similar functionality to a Table Box but with the ability to lock the sort order create a Chart with a type of Straight Table, add your dimensions and a single expression with just the value 1. In the presentation tab you can then suppress the expression column showing by selecting 'Hide Column'.

Once you have done this you will have the Allow Interactive Sort checkbox as described above.

Hope that helps,

Steve

AW:Re: Set sort order on simple table box

johnw — Fri, 03 Sep 2010 00:48:29 GMT

I don't use table boxes in live applications. They're too limited for my taste. I always use a straight table intead with the hidden "1" expression like Steve mentioned.

AW:Re: Set sort order on simple table box

Fri, 03 Sep 2010 07:22:31 GMT

Thanks to all,

that was the kind of explanation I was looking for! I now know how to deal with this issue.

Best regards,

Georg

AW:Re: Set sort order on simple table box

kji — Fri, 03 Sep 2010 08:52:31 GMT

The hiddden 1 column isnt needed if you just uncheck "Suppress Zero-Values"

AW:Re: Set sort order on simple table box

johnw — Fri, 03 Sep 2010 16:36:21 GMT


Johan Idh wrote:The hiddden 1 column isnt needed if you just uncheck "Suppress Zero-Values"

I did not realize that. Thanks!

Re: AW:Re: Set sort order on simple table box

Thu, 28 Mar 2013 19:40:39 GMT

Thanks Steve and John for the info.

I've tried the Straight Table and it works. However, I can't change the header of the column as it keep disable that option.

Appreciate any help.

Trisha

Re: AW:Re: Set sort order on simple table box

Thu, 28 Mar 2013 19:41:08 GMT

Thanks Steve and John for the info.

I've tried the Straight Table and it works. However, I can't change the header of the column as it keep disable that option.

Appreciate any help.

Trisha

Re: AW:Re: Set sort order on simple table box

Thu, 28 Mar 2013 19:41:33 GMT

Thanks Steve and John for the info.

I've tried the Straight Table and it works. However, I can't change the header of the column as it keep disable that option.

Appreciate any help.

Trisha