topic Re: Sort order using an existing expression in a straight table in QlikView

Sort order using an existing expression in a straight table

Fri, 21 Nov 2014 09:31:43 GMT

Hi,

I am trying to sort a straight table using my first expression - I don't want to change the script.

It works fine initially but when the document gets reloaded the sort order is reset to the first dimension and I have to do it all over again.

For some reason Qlikview does not keep the sort order by an existing expression - we have experienced this issue lately.

Does anyone know why this is hapenning and how it can be resolved?

Thanks,

Nevie

Re: Sort order using an existing expression in a straight table

alexandros17 — Fri, 21 Nov 2014 09:33:51 GMT

I often use expression to sort tables and this has never happened to me, attach your document if it is possible

Re: Sort order using an existing expression in a straight table

Peter_Cammaert — Fri, 21 Nov 2014 09:35:05 GMT

What version of QlikView are you using? Does it happen in QV Desktop or in AJAX Client or in both?

Re: Sort order using an existing expression in a straight table

Fri, 21 Nov 2014 09:39:48 GMT

Sorry, I forgot to mention that my column is hidden.

Re: Sort order using an existing expression in a straight table

jagan — Fri, 21 Nov 2014 09:41:19 GMT

Hi,

Try like this

Chart Properties-> Sort -> Select First Dimension in Dimensions-> Uncheck Y value -> Select Expression

and give your expression there.

Hope this helps you.

Regards,

Jagan.

Re: Sort order using an existing expression in a straight table

Fri, 21 Nov 2014 09:43:56 GMT

Hi Jagan,

Thanks for your suggestion but straight tables do not have Y value as a sort option.

Re: Sort order using an existing expression in a straight table

Fri, 21 Nov 2014 09:49:48 GMT

I am using QlikView 11.
Not sure about Qv desktop and AJAX client?

Re: Sort order using an existing expression in a straight table

morganaaron — Tue, 03 Feb 2015 11:15:31 GMT

Going to bump this as I'm now experiencing the same issues - we have a table that has 3 dimensions that are both conditionally shown and hidden in the final output. I'm trying to sort the table on my first expression (which is the same for all 3 views of the table), but whenever I reopen the document the sort order reverts back to using the first dimension instead.

I can go down the route of replacing this one table with three, but does anyone know any reason it's doing this? If it's related to the hidden dimensions as above then I'm a bit stuck.