topic QV10 - Interactive sort does not appear to be working consistently in QlikView

QV10 - Interactive sort does not appear to be working consistently

Tue, 05 Apr 2011 20:21:35 GMT

Was curious if anyone else has experienced this issue. In QV 8.5, we were able to double-click on column headers for all chart expressions and have it toggle the sort between ascending and descending. In QV 10, however, double-clicking some column headers only sorts the expression values one way and will not allow toggling. In the chart properties, all of these columns are set to "Allow Interactive Sort".

Thanks,

Michael

QV10 - Interactive sort does not appear to be working consistently

Tue, 05 Apr 2011 21:26:16 GMT

Are you using any Chart Interrecord Functions like Above or Below? Those functions interfere with interactive sorting; there's no message - it just doesn't work when you double-click the heading.

QV10 - Interactive sort does not appear to be working consistently

johnw — Wed, 06 Apr 2011 00:21:23 GMT

Double clicking also doesn't work properly if you haven't selected a way to sort the column on the Sort tab.

QV10 - Interactive sort does not appear to be working consistently

Wed, 27 Apr 2011 12:06:20 GMT

I had the same problem. For me the reason was that there were inactive expressions above the expression that I wanted to change sort order for. Once I moved the expression above all inactive expressions, it worked fine.

/Johan Lund

AW:Re: QV10 - Interactive sort does not appear to be working consistently

brenner_martina — Wed, 27 Apr 2011 12:09:12 GMT

Hi,

did you check at least one of the sorting possibilities?

AW:Re: QV10 - Interactive sort does not appear to be working consistently

erichshiino — Wed, 27 Apr 2011 12:24:08 GMT

There must be at least one sorting possibility, but you also have to check if you have more than one and one of them doesnot make sense (sorting numbers as text).

I also had problems with expressions that were disabled or dimensions with problems (dimensions with errors didn't appear but they mess with sorting)

QV10 - Interactive sort does not appear to be working consistently

Fri, 30 Mar 2012 04:05:18 GMT

Johan's solution worked for me!

Re: QV10 - Interactive sort does not appear to be working consistently

Anonymous — Tue, 27 Nov 2012 11:22:11 GMT

Tested with QV11 SR2 64bits.

You're right, Johan. Thanks.

Any expression *below* any inactive (by clicking 'disable expression' checkbox or because enabling condition is not met) expression in the expressions list of the graphic object only sorts one way (ascending or descending, depending what was selected in the 'Sort' tab for that expression)

Trying to figure out a solution right now (I need conditional enabling of expressions and can't put the rest of them *above*)...