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

[#2]

Hi Bharat,

Can you please try below and let me know is it working?

Step1:

Script:

temp:

LOAD RowNo() as rank,[Choose a View] INLINE [

Choose a View

OG

OU

CSG

CO

MC

CR

] ;

Step2:

Create a multi box with "Choose a View".

Step3:

Check the order of the Choose a view

Stpe4: Go to Sort tab, and check only Expression and the rest please uncheck and write in the expression "rank"

And check whether are you getting the expected result.

Thanks,
Sreeman.

[#3]

Hi Bharat,

Check whether you are asking for this....

[bharatkishore]

The same problem..When ever i am selecting the particular column that one is selecting and not the default one OG is not coming first.. Only OU is coming first.

[bharatkishore]

No Sreemann.. the expected result is not coming..

[arulsettu]

check this one i updated version 12

[bharatkishore]

Hi Arul,

Still the same problem.

When i click OG the order is

Now when i select OU the order is changing and the highlighted OU comes first..

But my requirement is when i select OU also OG should come first..Not OU

[Digvijay_Singh]

I see below output with attached qvw, Can you see what difference it has compare to your qvw.

[bharatkishore]

Hi Vijay,

When select OU the selected OU should highlighted and and OG should come first.. But now what is happening the selected OU is coming first.. Even when you select OU..OU should be highlighted and OG should come first..Hope you have understood.

[Digvijay_Singh]

I know what you need, actually I wrote to Arul to see what difference my qvw has from his qvw to understand why it is working for him but not for us.

[Digvijay_Singh]

I don't have licensed version so cannot open an other user QVW.