topic Re: Sort Order in Multi Box in QlikView

Sort Order in Multi Box

nihhalmca — Mon, 03 Nov 2014 06:27:05 GMT

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.

Re: Sort Order in Multi Box

anbu1984 — Mon, 03 Nov 2014 06:33:31 GMT

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

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

Re: Sort Order in Multi Box

ashfaq_haseeb — Mon, 03 Nov 2014 06:34:04 GMT

Hi,

Check this

use this as your sort expression:

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

Regards

ASHFAQ

Re: Sort Order in Multi Box

jagan — Mon, 03 Nov 2014 06:52:37 GMT

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.

Re: Sort Order in Multi Box

aveeeeeee7en — Mon, 03 Nov 2014 07:12:13 GMT

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

Re: Sort Order in Multi Box

nihhalmca — Mon, 03 Nov 2014 07:39:05 GMT

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.

Re: Sort Order in Multi Box

nihhalmca — Mon, 03 Nov 2014 07:39:30 GMT

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.

Re: Sort Order in Multi Box

nihhalmca — Mon, 03 Nov 2014 07:39:43 GMT

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.