topic Re: Sorting by week number in QlikView

Sorting by week number

Tue, 20 Jan 2015 13:56:58 GMT

Hi All

I have a listbox which shows me the Weekstart date - Weekend date and the Week number.

Script:

Dual(num(if( month(WeekStart( RE_DAY) )<> month(RE_DAY), 1 , day(WeekStart( RE_DAY) )),'00')

&' - '&

Num(if( month(WeekEnd(RE_DAY))<> month(RE_DAY), day(RE_DAY) , day(WeekEnd( RE_DAY) )),'00'),

If(month(WeekStart( RE_DAY) )<> month( RE_DAY), 1 , day(WeekStart( RE_DAY) ))) &' Week '& Week(RE_DAY)as Weeks

I would like to sort this by Week from smallest to largest e.g

Week 2

Week 3

Week 5

How can I do this cause the listbox sort propeties is not helping?

Re: Sorting by week number

datanibbler — Tue, 20 Jan 2015 14:07:24 GMT

Hi,

there is a "formula" checkbox on the "Sort" tab in the dialog, no?

There you can enter the formula (using Subfield()) to split out the number which is the last segment in your constructed "Weeks"_field and specify ascending sort order.

HTH

Best regards,

DataNibbler

Re: Sorting by week number

nirmalraj_kj — Tue, 20 Jan 2015 14:09:44 GMT

Have you tried the Loadorder - Orginal under the sort tab?

Re: Sorting by week number

Anonymous — Tue, 20 Jan 2015 14:24:29 GMT

Go to sort tab and select expression .

write

=num(mid(Weeks,15,2))

you need to count your actual strings till 'k' (last string before numeric week no. ex.. 1 ,2 etc)

Hope your problem will be resolve.

Re: Sorting by week number

Tue, 20 Jan 2015 16:16:14 GMT

Thanks a lot

Re: Sorting by week number

Anonymous — Wed, 21 Jan 2015 10:50:17 GMT

ur welcome