Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
nihhalmca
Specialist II
Specialist II

Sort Order in Multi Box

Hi All,

I want to sort Product in Multibox object.

Ex: Product has Apple, Samsung, Nokia and Moto.

I want to sort product filed in multibox as Moto, Apple, Samsung and Nokia.

How can i do it.

Thanks in Advance,

NiHhal.

1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III

Hi,

Check this

use this as your sort expression:

=Dual(Product,match(Product ,'Moto','Apple','Samsung','Nokia')) 

Regards

ASHFAQ

View solution in original post

7 Replies
anbu1984
Master III
Master III

Add this expr in Properties --> Sort tab --> Expression

Match(Product ,'Moto','Apple', 'Samsung','Nokia')

ashfaq_haseeb
Champion III
Champion III

Hi,

Check this

use this as your sort expression:

=Dual(Product,match(Product ,'Moto','Apple','Samsung','Nokia')) 

Regards

ASHFAQ

jagan
Partner - Champion III
Partner - Champion III

Hi,

Try like this

LOAD
Dual(Brand, RecNo()) AS Brand

INLINE [

Brand

Moto

Apple

Samsung

Nokia];


Now in Sort tab select Numeric Ascending.


Hope this helps you.


Regards,

jagan.

aveeeeeee7en
Specialist III
Specialist III

This is something new................!!


nihhalmca
Specialist II
Specialist II
Author

Actually what i posted question is wrong (my intention is different) ok anyways your answers are right, thanks for your response. i am closing this message.

nihhalmca
Specialist II
Specialist II
Author

Actually what i posted question is wrong (my intention is different) ok anyways your answers are right, thanks for your response. i am closing this message.

nihhalmca
Specialist II
Specialist II
Author

Actually what i posted question is wrong (my intention is different) ok anyways your answers are right, thanks for your response. i am closing this message.