topic Re: Sort Table By Specified Column Selection in QlikView

Sort Table By Specified Column Selection

Wed, 19 Dec 2012 15:55:44 GMT

I'm trying to sort a Straight Table by, depending on the user column selection.

If possible, I would like to do so via a macro, as the same user selection will be applied to several charts (easier to copy to the other charts).

The user can select 1 of 3 criteria, which is stored in a variable 'Order_By'.

Then I tried using the macro below:

Sub Order_By

If ActiveDocument.Variables("Order_By").GetContent.String = "SIR No" Then

ActiveDocument.GetSheetObject("Table_All").SortBy 1

Else

If ActiveDocument.Variables("Order_By").GetContent.String = "Application" Then

ActiveDocument.GetSheetObject("Table_All").SortBy 3

Else

If ActiveDocument.Variables("Order_By").GetContent.String = "Status" Then

ActiveDocument.GetSheetObject("Table_All").SortBy 33

End If

End Sub

This doesn't fully work.

Also it seems to mess up the 'Sort By Columns Priority', if I take a look at the chart properties.

How can achieve a simple sort by a specified column ?

Thanks

Re: Sort Table By Specified Column Selection

Wed, 19 Dec 2012 16:11:39 GMT

I would suggest avoiding macros whenever possible. See if the attached file is kind of what you are looking for.

Re: Sort Table By Specified Column Selection

b_garside — Thu, 23 May 2013 18:44:59 GMT

Great Solution Rebecca! Im going to try this as well.

Re: Sort Table By Specified Column Selection

b_garside — Fri, 24 May 2013 16:31:32 GMT

Rebecca, do you know how I would sort a Project list that is text based vs Numerical?

Does it need a function like MinString or just the Field value its self?

I have aMonth field that wont sort unless I move it to the top of the Sort list. I used Num to ensure it was numerical when using Sum but that wont work when used my expression completely. Is kind of sorts but not until I promote it to the top.

Any ideas

Re: Sort Table By Specified Column Selection

Fri, 24 May 2013 21:24:08 GMT

Ok, so I figured out one way that may help you. I created a new field that uses Ord() to give each SalesRepName a numeric ranking and then used that field in the %Calc field. Note that it will only be alphabetical through the third character of the text string unless you add to my formula. Hope it helps!!

Re: Sort Table By Specified Column Selection

Fri, 24 May 2013 21:28:18 GMT

Gysbert Wassenaar, swuehl, Michael Solomovich... do you guys have any better ideas?

Re: Sort Table By Specified Column Selection

Gysbert_Wassenaar — Sat, 25 May 2013 07:08:33 GMT

Nope, just a minor change. As far as I can tell it's possible to use rank(Sales Rep) to sort the Sales Rep field. The Ord field won't be necessary then. Or you could first load the sales reps in a temp table, then sort it and store it in a qvd and finally load the sales reps again from the qvd and join it with the rest of the data.

Re: Sort Table By Specified Column Selection

b_garside — Tue, 28 May 2013 14:37:56 GMT

Thank you both! Very Clever. Sorting it in the Script really helped.

Re: Sort Table By Specified Column Selection

Wed, 12 Jun 2013 12:35:45 GMT

Hello sir,

i have also same problem of sorting. I am using pivot table and i want to sort 2nd column as per selection but it's working wiyh abve logic can u pls help me in this.

Thank u in advance.

Re: Sort Table By Specified Column Selection

b_garside — Wed, 12 Jun 2013 13:32:49 GMT

I would use the sample Gysbert provided. I essentially use the same sorting method by joining a pre-sorted QVD with my existing table. The formula used is also provided in a table. =$(=SortExp) you specify the sort exp in a separate table and place the field in the Sort field. Then when you select form lsit box is will select the proper expression to sort on.

Provide a screenshot or sample QVW for more assistance.

Re: Sort Table By Specified Column Selection

acandido84 — Tue, 14 Jun 2016 13:03:01 GMT

Hello Rebecca . I'm trying to run what do you showed in the example ... I need to sort the columns Cause value and value payment is made .. can help me ...