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

[arulsettu]

hi

in properties sort tab disable all and enable load order. that will help u

[bharatkishore]

Hi Arul,

Thanks for your reply.. But it is not working..the selected one OU comes first then rest of the order.. But i want OG to come first but always one selected should be OU.

Thanks

[arulsettu]

like this

[Anonymous]

In scripting gibe the which order required by using the Inline function  or go the properties and go to the sort tab and have the expression write your column name as per column sort the values

[bharatkishore]

yes Arul..I need exactly the same.. Can you tell me how can we achieve this.

[Anonymous]

Have the function always one selection  there click there

[arulsettu]

inline should be like this

LOAD * INLINE [

    Choose a View

    OG

    OU

    CSG

    CO

    MC

    CR

];

and follow the first image for sorting. load original option in sorting.

[Digvijay_Singh]

Which QV version you have as it is not working in QV 11?

[bharatkishore]

I have given the same.. But still i am facing the same issue...Please remember OU should be always one selected value..Is possible can you please attach a sample test file if you have achieved this.