topic Sorting options in Straight Table in QlikView

Sorting options in Straight Table

hkg_qlik — Tue, 11 Jan 2011 01:45:25 GMT

Hi,

When I make any Straight table I can only assign a single sort (ASC or DESC) on any one of the column name in the table.

Is there a way where I can provide interactive sort option for each Expression in the Straight table for the end user?

For example: I have a Revenue & COGS table with Customer Name, Number, Sales Amt, Revenue Amt, Invoice Date and so on..

In the present scenario I can develop a Straight table with any of the above mention expression for a interactive sort: Like Revenue Amt (DESC)

Can we have the same type of sorting available for each expression on the same table?

Thanks,

Sorting options in Straight Table

Tue, 11 Jan 2011 02:24:56 GMT

Hi Hkgnadhi,

In the Straight Table , Sort the Expressions you have written in Ascending or Descinding using the Sort Tab. If you double click on the Header Column of every expression you can see the sort symbol using which you can sort in the required order . The Sort Symbol is seen in all the expression header if you double click on the Header...

Regards,

Chakravarthy.

Sorting options in Straight Table

hkg_qlik — Tue, 11 Jan 2011 02:28:04 GMT

Can we have both ASC and DESC options for same expression.

For example: For the first double click on a expression it will give ASC order and on the same expression if we again double click it will give DESC order.

Is that possible...if yes can you explain.

Thanks,

Sorting options in Straight Table

johnw — Tue, 11 Jan 2011 02:35:59 GMT

Yes, the first double click will give you one order, the next the other.

Sorting options in Straight Table

hkg_qlik — Tue, 11 Jan 2011 02:47:51 GMT

Somehow its not working for me.

If I click twice it only gives me one order thats DESC.

Do I have to enable anything in the SORT tab?

Thanks,

Sorting options in Straight Table

johnw — Tue, 11 Jan 2011 02:55:56 GMT

"Allow Interactive Sort" on the sort tab, but I believe it should be checked by default.

Sorting options in Straight Table

Tue, 27 Sep 2011 08:28:21 GMT

Hi am having the exact same problem and cannot get the interactive sort to work

Any suggestions?

Thanks

Re: Sorting options in Straight Table

Fri, 03 Feb 2012 05:19:02 GMT

Eventually figured out why certain of my columns suddenly stopped sorting interactively, even though “Allow interactive sort” was enabled

Check for Disabled expressions (red circle with a cross through it) and move these expressions right to the bottom of your expression list. It appears that sorting is problamatic only on those expressions (columns) below the disabled expression.