topic Re: sorting expressions (columns) in aplhabetical order in QlikView

sorting expressions (columns) in aplhabetical order

Mon, 25 Jan 2016 08:48:47 GMT

Hi,

I'm hoping there is a solution to this as it's driving us crazy.

We have a very big straight table with about 60 columns (done in reponse to a table box not being able to cope with data); however, the expressions definitions don't seem to be in any order. If causing a lot of difficulty and time when trying to find a column. We want it in alphabetical order

There isnt the 'text order' option in a table box and existing fuctions of 'sort' within the staright table doesnt seem to actually sort the data. Here is current setup:

You can see even picking text 'a-z' its still not in order:

Re: sorting expressions (columns) in aplhabetical order

Anonymous — Mon, 25 Jan 2016 08:52:31 GMT

That would not be possible...

But yes, you can promote or demote your expression in alphabatically order

Re: sorting expressions (columns) in aplhabetical order

MK_QSL — Mon, 25 Jan 2016 08:55:05 GMT

You have to go to Expressions tab and try to sort manually by Promote and Demote option..

Re: sorting expressions (columns) in aplhabetical order

jagan — Mon, 25 Jan 2016 08:58:00 GMT

Hi,

In Expressions tab you have to manually sort by using Promote and demote buttons. No other way for this.

Regards,

Jagan.

Re: sorting expressions (columns) in aplhabetical order

jonathandienst — Mon, 25 Jan 2016 08:58:00 GMT

According to your screen shot, the field with the highest sort priority is Void Cost, which sounds like a numeric field. Sorting this alphabetically may give inconsistent results. Promote Address to the highest priority (in the dialog or interactively on the chart) and ensure that field is A-Z sorted.

Re: sorting expressions (columns) in aplhabetical order

amit_saini — Mon, 25 Jan 2016 08:58:18 GMT

Hi Chris,

Sorry this is not possible, only option is to promote or demote as Balraj suggested.

But let's wait for other views on this.

Thanks,
AS