topic Sorting in Straight table in QlikView

Sorting in Straight table

Anonymous — Tue, 15 Feb 2011 10:43:33 GMT

Hi,

I am using Straight table in my application.

In Straight table sorting is not working for me in both ways like Ascending as well as descending.Requirement is user should sort in both ways Ascending as well as Descending.

When I was working on this what I have seen is Sorting works good when data is less in Straight table but it's noty working in my real application wherein data is more.

Can you please give your inputs on this?

Regards,

Swapnil

Sorting in Straight table

Tue, 15 Feb 2011 11:19:03 GMT

HI swapnil ,

Whats the size of your data in application ??? can you share it.

There allways a performance issue when data is more , try to increase your hardware as per your data. beacuse as per your inputs its working fine when data is less.

Sorting in Straight table

Tue, 15 Feb 2011 11:22:18 GMT

Hi Swapnil

Which Version of Qlikview you are Using?

There may be performance issue

Sorting in Straight table

maneshkhottcpl — Tue, 15 Feb 2011 11:30:07 GMT

Hi,

Please check the Interactive Sort is enabled or not?

It is in the Property-- Sort-- Below Priority

Then use double click on column, and verify.

Thanks

Manesh

Sorting in Straight table

Anonymous — Tue, 15 Feb 2011 11:42:24 GMT

Thanks for the quick reply.

Interactive sort option is on.

I am using QlikView 10 version.

Data size is around 10 Mb and 1500 rows in the pivot on which I am trying sorting.

What I can see is text columns are working fine when we keep sort order Text (A-> Z) but columns with Numeric values are not working properly.

Sorting in Straight table

Tue, 15 Feb 2011 12:22:19 GMT

Have you got the sort order correct in the Sort tab ... giving the columns the correct priority?

Also, you mention Pivot ... is it definitely a Straight table?

Sorting in Straight table

Tue, 15 Feb 2011 12:33:51 GMT

HI swapnil,

GO to Properties > Sort >

Now select your filed where you need accending or decending , and check accending / decending.

Just clik on the filed name on the table if its accending it will change to decending and vica versa.

I hope this will work.

Sorting in Straight table

Anonymous — Tue, 15 Feb 2011 13:59:40 GMT

Yes its a straight table.

I have done the same thing. Properties--> Sort and setup the sorting Ascending or descending as required on columns. Problem which I am facing is if I set up Ascending then it sorts in ascending by double clicking and then if I again double click for descending then it doesnt work. Ideally it should work thats how sorting is required.

Sorting in Straight table

Tue, 15 Feb 2011 14:14:17 GMT

Its working very fi9 at my end. 🙂

It would be help full for us if you can share your application.

Sorting in Straight table

Tue, 15 Feb 2011 17:49:59 GMT

Swapnil, Can you please check your application with limited reloaded data say 1000 records ?

Regards--

Nayan

Re: Sorting in Straight table

Wed, 19 Sep 2012 12:12:41 GMT

I had exactly the same problem today (QlikView 10 SR3), double-clicking on a column in a straight table only sorted it in the default direction, so it didn't switch between ascending and descending.

Here's how I've fixed it:

- there were a couple of disabled expressions before the column thatI tried to sort (+ a cycle group)

- I deleted these disabled expressions and the sorting started to work as normal

Best regards,

Robert