topic Re: Straight Table Sorting Problem in QlikView

Straight Table Sorting Problem

Wed, 06 Feb 2013 20:04:44 GMT

Hello,

I have a problem with the sorting in my straight table- everything works normally as long as I do not use an expression in the 'background color' of my expressions or dimensions. However, if I do add a background color expression to either the table dimension or any of the expressions, suddenly the sorting does not work at all.

Regardless of whether interactive sort is checked or not (and the priority of the expressions in the sort list), the sorting for the chart completely ignores everything except the dimension sort order. In other words it becomes impossible to sort by any of the expressions (interactively or otherwise).

Using QV11SR2.

Any help or suggestions would be greatly appreciated.

--Ben

Re: Straight Table Sorting Problem

Wed, 06 Feb 2013 20:21:10 GMT

Ben

This sounds very much like a bug to me, I'm not at a workstation to check it myself but I would guess you should report this to support, you never know, there might already be a patch available to fix it.

Email support@qlik.com

Re: Straight Table Sorting Problem

Anonymous — Wed, 06 Feb 2013 20:46:04 GMT

Ben,

Are you using conditional show for expressions? We have sorting problem in straight tables with conditional expressions.

Not fixed in QV 11.2

Regards,

Michael

Re: Straight Table Sorting Problem

Wed, 06 Feb 2013 21:01:39 GMT

Hi Michael,

Actually there are no conditional dimensions or expressions in the chart, they all show all the time.

I have just discovered that the problem only occurs when I use the RowNo() function in the background color expression. I need the row colors to alternate though so that doesn't really solve the problem for me.

Regards,

--Ben

Re: Straight Table Sorting Problem

Wed, 06 Feb 2013 21:04:08 GMT

thanks for the suggestion Nigel. Unfortunately, it appears "Support no longer take Emails to open support tickets"....

Re: Straight Table Sorting Problem

Mon, 29 Jul 2013 09:09:35 GMT

Hi Michael,

I don't know if you still have this problem.

We also had it (QV 11 SR2) and we found a small tip to make it works. When you save the qvw file, be sure to display all the columns (by selecting all of them). If we forget one or more columns, the sort on the table won't work...

Hope it helps

Damien

Re: Straight Table Sorting Problem

Anonymous — Mon, 29 Jul 2013 12:28:53 GMT

Hi Damien,

Thanks for the tip, good to know.

Re: Straight Table Sorting Problem

Thu, 10 Apr 2014 17:52:18 GMT

Hi Michael,

Can you provide links to some documents regarding the sorting order issue. I am facing the same issue when I try to sort a straight table with conditional dimensions and expressions.

Regards,

Re: Straight Table Sorting Problem

Anonymous — Thu, 10 Apr 2014 19:39:57 GMT

Not aware of any documents about that, sorry.

Re: Straight Table Sorting Problem

Thu, 10 Apr 2014 23:18:13 GMT

Hi Michael,

Can you provide me a brief description of the bug? I am facing problem in implementing a custom sort on a straight table with multiple conditional dimensions/expressions. I need to know if this is due to the bug that you referred to.

Regards,

Rajdeep Biswas

Re: Straight Table Sorting Problem

Anonymous — Thu, 05 Nov 2015 19:07:31 GMT

I have this problem, too. Still exists in QV 11.2 SR12

I logged a support call for this. Will see what comes up...

Update 12-NOV-2015 Their response is that it is not possible to sort on a column containing a condition, and that you can propose to add the feature if you wish.

At the very least there should be a warning saying that the sort will not work when you select such a column...

Re: Straight Table Sorting Problem

Anonymous — Mon, 07 Dec 2015 20:11:29 GMT

Come on Qlik, really?

Hope this will be fixed in QV 12

Re: Straight Table Sorting Problem

agni_gold — Mon, 10 Jul 2017 14:53:56 GMT

Is this bug corrected in qv12 ?

Re: Straight Table Sorting Problem

warfollowmy_ver — Thu, 13 Dec 2018 05:54:41 GMT

I'm just beside myself with anger.
This problem has not been solved until now. I ran into this. Tried to bypass the problem made a macro, it works great (https://community.qlik.com/t5/QlikView-App-Development/Change-sort-priority-in-straight-table-with-macro/m-p/1519732#M437403).
But with the trigger after opening at the end, the straight table still resets the sort. The report is up-to-date and updated frequently, so this is a pain for users.

Thanks QlikTech for having thrown QV and doing only QS.

Re: Straight Table Sorting Problem

warfollowmy_ver — Thu, 13 Dec 2018 23:44:25 GMT

In the end I managed to get around this problem.
I created a variable in the boot script LET Trigger = '= now ()';

I also made a trigger when changing the Trigger (variable) to run a macro (that is higher in the message) and reset the Trigger (variable).

This option works in contrast to the trigger when opening.