topic Re: Listbox in QlikView

Listbox

rathnam_qv — Wed, 17 Jul 2013 11:16:59 GMT

Hi all,

i have list box like Jan to Dec.....but it is not in correct order.i want to display it like JAN,FEB,MAR.....DEC

help me...

Thanks!!!

Smiley

Re: Listbox

Anonymous — Wed, 17 Jul 2013 11:19:39 GMT

Change Sort order to Numeric, or to Load Order.

Jonathan

Re: Listbox

jvitantonio — Wed, 17 Jul 2013 11:25:40 GMT

That depends on the type of field. In your case, it might be a simple string field. In your script, create a dual field like:

Load

dual(MonthName, MonthNumber) as Month

From...

Where MonthName is the field containing the month name and Month number is the month number.

Dual will allow you to see the month name but behind it, it will behave as a number, making sorting easy to implement.

Re: Listbox

rathnam_qv — Wed, 17 Jul 2013 11:32:53 GMT

hey still it is not happening...

Re: Listbox

kaushiknsolanki — Wed, 17 Jul 2013 11:56:16 GMT

Hi,

Create an inline table something like below.

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.

Regards,

Kaushik Solanki

Re: Listbox

Wed, 17 Jul 2013 12:00:51 GMT

try this

LOAD *,

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

INLINE [

id, price, field

1, 2, Jan

2, 3, May

3, 0,Mar

4, 5,Apr

5, 1,Feb

];