topic Re: Sorting a month list box in QlikView

Sorting a month list box

Fri, 22 Jun 2012 14:39:08 GMT

I created a "month" field from a key, in my script, using the make date feature. When I created the list box to show the months (01, 02, 03, etc) I used an expression to show the months as Jan, Feb, Mar, etc. Now, the list box sorts correctly when I use the sort by expression, = Month expression. When users are accessing the document (via accesspoint) the sorting is all mixed up.

When I re-sort the qvw file it seems to fix it, but only temporarily.

Anyone else experience this problem, or know how I can solve this issue?

Re: Sorting a month list box

deepakk — Fri, 22 Jun 2012 14:54:26 GMT

hi,

Instead of doint it in expression do it at script level and bring it as a field.

Deepak

Re: Sorting a month list box

Fri, 22 Jun 2012 19:29:21 GMT

Hi Mike,

In the sort expression use Only function with a set analysis and ignore the selections users are making.

which helps you to remain the sort order same.

hope this helps

thank you

Meher

Re: Sorting a month list box

Sat, 23 Jun 2012 05:31:46 GMT

suggest you create a calendar master data....or at least a field of MMM YYYY, so when you need 2011 June to 2012 June, it will be sorted properly... just use date(date, 'MMMYYYY')