topic Re: sorting in a different order in QlikView

sorting in a different order

antonrus — Mon, 14 Apr 2014 06:02:08 GMT

Hello! Please help to solve one problem. I have a table of revenue on weekdays. It displays the days of the week in order, starting from Monday. And should that be showed with the environment, ie sort in a different order, such as not allowing it (sorry, do not speak in English)

Re: sorting in a different order

tresB — Mon, 14 Apr 2014 06:11:22 GMT

Take a straight table-> Sort tab-> Allow interactive sort

Re: sorting in a different order

antonrus — Mon, 14 Apr 2014 06:20:20 GMT

Yes, this has put a tick. But now sort random string? When I try to drag them - they just do not want me to impose a filter on the day of the week.

Re: sorting in a different order

kangaroomac — Mon, 14 Apr 2014 06:23:14 GMT

Hiya,

Or if you want your table sorted in a specefic way, i.e. Ascending (small to big),

Right Click the table
Properties
Go to the Sort Tab

Re: sorting in a different order

kangaroomac — Mon, 14 Apr 2014 06:25:47 GMT

Try sorting it on Load Order

and in your script, load the field with the dates as:

ORDER BY myDate ASC;

This way it will load days in ascending order, and with load order chosen in your Sort tab, should give you the days of the week in the desired order.

Re: sorting in a different order

tresB — Mon, 14 Apr 2014 06:26:52 GMT

You mean, users would define their won sort order? No, that won't be possible that way. Iteractive sort only allows asc or desc sort. If you want a specific order which is predefined, you can do that in an expression of sort tab.

Re: sorting in a different order

antonrus — Mon, 14 Apr 2014 06:28:18 GMT

Thank you. But now I have shows in the following order: Monday; Tuesday; Wednesday; Thuesday; Friday; Saturday; Sunday

And that should be started with the environment:

Wednesday; Thuesday; Friday; Saturday; Sunday; Monday; Tuesday

Re: sorting in a different order

tresB — Mon, 14 Apr 2014 06:32:48 GMT

In the expression of sort tab, try something like:

Match(YourWeekField, 'Wednesday','Thuesday', 'Friday', 'Saturday', 'Sunday', 'Monday', 'Tuesday')

Or,

Dual(YourWeekField, Match(YourWeekField, 'Wednesday','Thuesday', 'Friday', 'Saturday', 'Sunday', 'Monday', 'Tuesday'))

Re: sorting in a different order

kangaroomac — Mon, 14 Apr 2014 06:36:14 GMT

Load an inline table, with something like:

* INLINE [
Sort_Day, WeekDay
1, 3

         2, 4
         3, 5
         4, 6
         5, 7
         6, 1
         7, 2
];

and link it to your loaded field, with the date field having something like

...

WeekDay(myDate) AS WeekDay

and in your front-end sort by Sort_Day Ascending.

Re: sorting in a different order

antonrus — Mon, 14 Apr 2014 06:38:02 GMT

Hooray! It works! Thank you and all who responded to my question!

(Two weeks of work - but because of this problem, the whole project was in jeopardy, but you saved it)

Re: sorting in a different order

antonrus — Mon, 14 Apr 2014 06:43:26 GMT

Thank you for your answer, despite the fact that the decision has already been found, take yourself and your advice.