topic Re: Dynamic sorting in Straight table chart in QlikView

Dynamic sorting in Straight table chart

Fri, 02 Apr 2010 13:21:48 GMT

The Straight table chart provides an option to sort the data by any of the available columns but one at a time.

I've a peculiar requirement where the user wants to be able to sort the data on multiple fields,i.e. he should be able to select multiple fields and then sort the data.

Can we achieve this by some configuration/macro ?

Dynamic sorting in Straight table chart

johnw — Tue, 06 Apr 2010 01:13:17 GMT

To sort by multiple fields, just work in reverse order. Let's say you have a "First Name" column and a "Last Name" column. If you want to sort by First Name and Last Name (putting "Bob Smith" before "Mary Smith" before "Will Anderson"), just double click on the columns in the opposite order - Last Name, then First Name. That's a very common sorting behavior in GUIs, so learning it should help your user in more than just QlikView.

Dynamic sorting in Straight table chart

Wed, 12 May 2010 13:10:54 GMT

Thanks for your inputs John.

Sorry for the delayed reply as this requirement had got kinda subdued for a while and I have not worked much on this after that.

Your approach does make sense and as you have said it is a common sorting behaviour in GUIs. But, I was just wondering if there is an option to select multiple fields at once and then choosing to sort.

Well, it may sound a bit excel-ish but I wanted to check if there is something available like that.

Thanks anyways.

Dynamic sorting in Straight table chart

johnw — Thu, 13 May 2010 00:47:28 GMT

Well, supporting Excel-style sorting certainly seems like an obvious enhancement, even if it's low priority since it can be done already in a different way. Perhaps they'll add it some day.

Re: Dynamic sorting in Straight table chart

Thu, 25 Feb 2016 22:00:55 GMT

Were you able to find a solution to sort straight table on multiple columns. I have sub-totals in my straight table which I calculate at script level and display in UI. All of it changes if I allow Interactive sort. I want to sort straight table first by one column and then by another column

Re: Dynamic sorting in Straight table chart

chriys1337 — Thu, 27 Jul 2017 08:50:32 GMT

Hi Priyadarsini Krishnamurthy did you find a solution to set priority to the sorting first by your 2nd column, and than 1st column?

best Regards,

Chris