topic Re: have list box issue in QlikView

have list box issue

NavinReddy — Wed, 17 Jul 2013 11:33:23 GMT

Hi Community,

i have list box issue

I have list box like Jan ,April,Aug ,Dec,Feb,july,march,nov....

but i need to be arrange Jan,Feb,March,April,May,June,July....

I tried but Accesding order every thing

Is there any manually arrange

Could some one help me

Thanks in Advance,

Rohith

Re: have list box issue

hic — Wed, 17 Jul 2013 11:45:54 GMT

If you create this field using the Month() function, the values will be dual (both text and number) and they will be sorted automatically.

HIC

Re: have list box issue

Joaquin_Lazaro — Wed, 17 Jul 2013 11:49:52 GMT

On Properties/Order tab there are different metods to order this, try with an expression or load order

Re: have list box issue

NavinReddy — Wed, 17 Jul 2013 11:53:21 GMT

Hi Henric,

now also i got same issue

i didn't get give some example

Thanks,

Niranjan

Re: have list box issue

Wed, 17 Jul 2013 11:54:19 GMT

try this

month(date(date#(field,'MMM'),'MMM')) as month

Re: have list box issue

Wed, 17 Jul 2013 11:59:17 GMT

suppose your field name in listbix is fieldmonth

in listbox properties-

general tab--> select dropdown in Field--> select expression --> then write this code-

month(date(date#(fieldmonth,'MMM'),'MMM'))

Re: have list box issue

NavinReddy — Wed, 17 Jul 2013 12:10:22 GMT

Inline:

Load * inline [

Month, MonthSort

JAN,1

FEB,2

Mar,3

];

Make sure that the Month field name links with your month field in data model.

Now go to the listbox properties- > Sort ->Select Expression ->Type MonthSort.

its working fine but if i press Jan it goes some where

it con't Stable at

Thanks,

Rohith

Re: have list box issue

Wed, 17 Jul 2013 12:12:44 GMT

Hi,

Goto your list box --> Sort --> Expression (Paste the expression =Date#(Your month field,'MMM')) and have it as asending order.

Regards,

Kabilan K.

Re: have list box issue

kaushiknsolanki — Wed, 17 Jul 2013 12:17:15 GMT

Hi,

Yes, in sort option you will see the first option State, Check that and say Ascending.

Regards,

Kaushik Solanki