topic Ordering time period in Multi Selection Object in QlikView

Ordering time period in Multi Selection Object

Fri, 06 Jan 2012 14:30:19 GMT

Hello,

I have a field to group times like:

Until 3 Months

Until 6 Months

Until 10 Months

Until 1 Year

Until 1,5 Year

I need to order it in this order on Multi Selecion object and in a chart.

Someone can help me?

Thank you

Ordering time period in Multi Selection Object

swuehl — Fri, 06 Jan 2012 14:36:57 GMT

If your load order is like above, I think you can just use load order as sort order.

Another option is to create dual values for each field value, with a text and a numerical representation. Use the numerical representation for sort order.

LOAD dual(FIELD,recno()) as FIELD

INLINE [

FIELD

Until 3 Months

Until 6 Months

...

];

Ordering time period in Multi Selection Object

sridhar240784 — Fri, 06 Jan 2012 14:53:04 GMT

One more option would be , simply load your information in line table with the order you want to sort and you may also drop the line table at the end of the script. You can now sort the field in multi box using Load order.i.e Right Clik on MultiBox--> Properties-->Sort Tab-->Sort By "Load Order"

Hope this helps you.

-Sridhar