Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Ordering time period in Multi Selection Object

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

1 Solution

Accepted Solutions
MVP
MVP

Ordering time period in Multi Selection Object

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.

Like

LOAD dual(FIELD,recno()) as FIELD

INLINE [

FIELD

Until 3 Months

Until 6 Months

...

];

2 Replies
MVP
MVP

Ordering time period in Multi Selection Object

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.

Like

LOAD dual(FIELD,recno()) as FIELD

INLINE [

FIELD

Until 3 Months

Until 6 Months

...

];

sridhar240784
Contributor III

Ordering time period in Multi Selection Object

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

Community Browser