topic Help with sorting in QlikView

Help with sorting

fcecconi — Mon, 22 Jun 2015 02:53:49 GMT

I am trying to sort a straight table by more than 1 column. I have created 3 columns that will rank the data based on what columns the user selects. This method works great for sorts on one column. If the user selects a sort that would required 2 columns be sorted, the application will only sort by 1 column and ignore the other;

All of the ranking objects have an ascending sort enabled and the other objects don't have any sort associated with them.

any suggestions is greatly appreciated.

Re: Help with sorting

jagan — Mon, 22 Jun 2015 03:05:16 GMT

Hi,

If you attach the sample file then it would be easier to provide the solution. I think if you define the order of the dimensions in the Sort tab correctly then it will sort according. Order the Dimensions in Sort tab by

Chart Properties -> Sort -> Columns (Priority) -> Change the priority by using Promote and Demote buttons.

Hope this helps you.

Regards,

Jagan.

Re: Help with sorting

fcecconi — Mon, 22 Jun 2015 12:40:18 GMT

Unfortunately I can't post my application due to company policy. I have already have the 3 rank columns in the proper sort priority.

Re: Help with sorting

fcecconi — Mon, 22 Jun 2015 12:49:31 GMT

Here is my sort priority screenshot

Re: Help with sorting

fcecconi — Mon, 22 Jun 2015 19:53:27 GMT

Issue was due to the mode in the Ranking statement. I switch from ,4 to ,1 and everything is sorting as expected.