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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST 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.