topic Re: Multi box sorting order in QlikView

Multi box sorting order

bharatkishore — Wed, 02 Mar 2016 10:49:33 GMT

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

CSG

];

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

CSG

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

CSG

Can you guys please help me on this.

Thanks

Bharat

Re: Multi box sorting order

sunny_talwar — Wed, 02 Mar 2016 10:53:22 GMT

May be use Load order as your sort and uncheck 'State' on the sort tab

UPDATE: Same settings for multibox also works

Re: Multi box sorting order

alexandros17 — Wed, 02 Mar 2016 10:54:09 GMT

In the sort tab uncheck all boxes and check "load Order"

Let me know

Re: Multi box sorting order

Chanty4u — Wed, 02 Mar 2016 10:54:36 GMT

alrdy there

Sorting order in Multi Box

Re: Multi box sorting order

bharatkishore — Wed, 02 Mar 2016 10:56:57 GMT

Hi Sunny..I am using desktop version with a leased license and my qlikview version is QV11 SR12.

Not sure why i am unable to do..

Re: Multi box sorting order

bharatkishore — Wed, 02 Mar 2016 10:58:51 GMT

I have done all those but still i am unable to do...Please check the attached test file..

Re: Multi box sorting order

sunny_talwar — Wed, 02 Mar 2016 11:00:01 GMT

What version of QV are you using, the attached seem to work as you want on QV12

Re: Multi box sorting order

bharatkishore — Wed, 02 Mar 2016 11:02:28 GMT

I am using QV11 SR12..But i don't know what is causing the issue.. I am unable to get that requirement..

Re: Multi box sorting order

sunny_talwar — Wed, 02 Mar 2016 11:04:47 GMT

Can you share a screenshot of what you are seeing?

Re: Multi box sorting order

alexandros17 — Wed, 02 Mar 2016 11:05:03 GMT

It seems to work correctly (QV 11),

Re: Multi box sorting order

bharatkishore — Wed, 02 Mar 2016 11:09:45 GMT

Please see the below screenshot

I don't know i am getting this one and also made in sort tab load order as original

Re: Multi box sorting order

sunny_talwar — Wed, 02 Mar 2016 11:12:44 GMT

And did you also remove the check mark for 'State' correct?

Re: Multi box sorting order

bharatkishore — Wed, 02 Mar 2016 11:14:18 GMT

Yes.. i have removed for that as well..