Sorting order in Multi Box

[bharatkishore]

Hi Guys,

I have an small problem with the sorting order in qlikview. Let me explain in detail:

In the back end script i have written code as

LOAD * INLINE [

    Choose a View

    OG

    OU

    CSG

    CO

    MC

    CR

];

     i have created a multibox and loaded the field Choose a view.

And i selected "always one selected value" i.e. OU and it will be selected all the time. But When i select the multi box button the order will come as OU defautly selected and the rest of order will be

    OG

    CSG

    CO

    MC

    CR

But my requirement is the multi box should be displayed as(With OU should be always selected)

    OG

    OU

    CSG

    CO

    MC

    CR

Can you guys please help me on this.

Thanks

Bharat

[tamilarasu]

Hi Bharat,

Use load order as "Original" in sort tab like below.

 

Hope this works for you!

[tamilarasu]

Working fine in SR 9.

[Chanty4u]

Hmm tq raj...for me its nt wrkng

[arulsettu]

can u upload ur sample

[#6]

Hi Bharat,

Can you please see the attachment and let me still you cant able to get the sorted order.

Thanks,

Sreeman.

[bharatkishore]

Hi Nagaraj,

It is not working...

[bharatkishore]

Hi Sreeman,

It is not working...

[bharatkishore]

Is it because of SR12??

[tamilarasu]

I am not sure whether this is bug or not. It's working fine in SR 9 version. You can also try sort expression as

=Match([Choose a View],'OG','OU','CSG','CO','MC','MC')

[arulsettu]

did u checked my version 12 upload?