topic Sort List Box by state and then by date in QlikView

Sort List Box by state and then by date

bluishjoe — Thu, 19 Jul 2012 13:27:31 GMT

Hi, I have a List Box and its value is calculated by the expression

=MakeDate(ORDYEAR,ORDMONTH,ORDDAY)

I would like its values to be sorted first by state (possible or not possible) and then by its date value. I can't see this possibility to use more than one sorting rule giving them different priorities. Is there a way? Thanks!

Re: Sort List Box by state and then by date

CELAMBARASAN — Thu, 19 Jul 2012 13:36:25 GMT

use

sort by state and sort by number option in the sort tab

Re: Sort List Box by state and then by date

bluishjoe — Thu, 19 Jul 2012 13:54:03 GMT

Thanks.

I tried that: sort by State Auto Ascending (or Ascending) and by Numeric Value Ascending.

But it sorts by numeric value and possible values are mixed inside non-possible ones.

I need all possible values on the top, sorted by date, and then all non-possible values.

Re: Sort List Box by state and then by date

CELAMBARASAN — Thu, 19 Jul 2012 14:13:07 GMT

Is that list box doesn't have scroll? i mean all data in listbox can be viewable without scrolling?

Celambarasan

Re: Sort List Box by state and then by date

bluishjoe — Thu, 19 Jul 2012 15:48:29 GMT

It does have a scroll, it is a long list of dates.

Re: Sort List Box by state and then by date

Tue, 16 Oct 2012 14:05:37 GMT

I have the same problem (10 SR5). Sort works fine for State if the list is a simple field. But when I use an expression for the list I can't seem to do anything to make the items sort by state so that only valid options will show first.

In my case I have one list box that shows the system $Table values. If the user Qliks on a table then the other list box will show the $Field values. However, I don't want to show all of them I'm using the expression below to limit them.

= IF(Left($Field,1) <> '_' and Len($Field)>2, $Field)

Re: Sort List Box by state and then by date

Tue, 13 Nov 2012 11:00:50 GMT

Do you have tried the match-expression?

Match (text, mask_expr1, ...)

Own example:

Match( Day, 'Monday','Tuesday'.......,'Sunday')

Re: Sort List Box by state and then by date

bluishjoe — Tue, 13 Nov 2012 15:38:33 GMT

Hi Patryk! How does your suggestion can be applied to my case?

Match(...) should replace MakeDate(...)?

Note that I need a List Box with a list of dates in the form DD/MM/YYYY or similar.