topic Ordering Dates in QlikView

Ordering Dates

Fri, 09 Mar 2012 08:48:22 GMT

Hi All,

I have a month field. Jan - feb -mar etc. However in the list box the dates will not load in month order for some strange reason. Can i use the expression option in the Sort tab of the Properties and if so what do you write in there???

Thanks

Laura

Ordering Dates

CELAMBARASAN — Fri, 09 Mar 2012 08:54:20 GMT

Hi,

Try creating a separating one more field

Load * inline

[Month,MonthNum

jan,1

Feb,2

.];

Use Monthnum as Sort by expression.

How you have created the monthField?

Celambarasan

Ordering Dates

Fri, 09 Mar 2012 08:57:03 GMT

It is a field which is from the calendar. i want it to say jan, feb, march. i was wondering if i could use the dual function to solve my problem

Ordering Dates

CELAMBARASAN — Fri, 09 Mar 2012 09:02:36 GMT

Hi,

Ya you can use Dual function.

Load Dual(Month,MonthNum) as MonthFieldName inline

[Month,MonthNum

jan,1

Feb,2

.];

Did you created the month Field using Month() function?

Celambarasan

Ordering Dates

jagan — Fri, 09 Mar 2012 09:34:17 GMT

Hi,

Can you attach the sample file.

Regards,

Jagan.

Ordering Dates

Fri, 09 Mar 2012 10:08:16 GMT

Can i put that in the sort expression?

Ordering Dates

CELAMBARASAN — Fri, 09 Mar 2012 10:12:51 GMT

Hi,

This should be used inside the script only.

If you have to do it in sort expression use the below expr

=WildMatch(FieldName,'Jan','Feb','Mar','Apr','May'......)

Celambarasan

Ordering Dates

Fri, 09 Mar 2012 10:20:47 GMT

That worked, but say the user clicks march as a selection nothing stays in its orginal order.

Any ideas?

Ordering Dates

CELAMBARASAN — Fri, 09 Mar 2012 10:44:42 GMT

Hi,

Have you unchecked the Sort by State option?

Celambarasan