topic Re: Sorting in QlikView

Sorting

ashokraju — Wed, 25 Nov 2020 16:16:04 GMT

I have a colomn called 'BookingPeriod' values like jan 09,feb 09 to dec 16 in irregular order. How to sort these values in ascending order like jan 09 to dec 16.

Re: Sorting

tamilarasu — Thu, 29 Dec 2016 06:08:27 GMT

Hi Ashok,

Try this as sort expression in sort tab.

=Date#(BookingPeriod,'MMM YY')

Re: Sorting

Chanty4u — Thu, 29 Dec 2016 06:08:33 GMT

try below

using match ...sort tab expression.

=Match(MonthYear,'jan09......'dec16')

Re: Sorting

pathiqvd — Thu, 29 Dec 2016 06:17:41 GMT

Hi,

Try This,

Match(CAPITALIZE(LEFT(TRIM(fieldnname,3)),

$(=chr(39) & Replace(MonthNames, ';', chr(39) & ',' & chr(39)) & chr(39)))

+ (RIGHT(TRIM(fn),2) * 11)

Re: Sorting

ashokraju — Thu, 29 Dec 2016 07:10:05 GMT

I want dynamically. In future previous years will come that time this will not works.

Re: Sorting

ashokraju — Thu, 29 Dec 2016 07:10:42 GMT

hi..it is not working

Re: Sorting

tamilarasu — Thu, 29 Dec 2016 07:12:33 GMT

I did a test in a sample file and it's working fine. If possible, share your application.

Re: Sorting

Anil_Babu_Samineni — Thu, 29 Dec 2016 07:14:03 GMT

This should work, When you say it is not working you may share sample data

Re: Sorting

ninnartx — Thu, 29 Dec 2016 09:08:11 GMT

Maybe check and see if your field BookingPeriod is stored as text or date format first?

Re: Sorting

sunny_talwar — Thu, 29 Dec 2016 10:04:25 GMT

May be a slight variation of what Tamil has provided:

In the script:

Date(Date#(KeepChar(Upper(BookingPeriod), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'), 'MMMYY'), 'MMM-YY') as BookingPeriod

or front end (dimension or sorting expression)

Date(Date#(KeepChar(Upper(BookingPeriod), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789'), 'MMMYY'), 'MMM-YY')