topic Re: Sorting order in Multi Box in QlikView

Sorting order in Multi Box

bharatkishore — Wed, 02 Mar 2016 06:48:04 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: Sorting order in Multi Box

arulsettu — Wed, 02 Mar 2016 06:54:33 GMT

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

Re: Sorting order in Multi Box

bharatkishore — Wed, 02 Mar 2016 06:57:41 GMT

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

Re: Sorting order in Multi Box

arulsettu — Wed, 02 Mar 2016 07:00:55 GMT

like this

Re: Sorting order in Multi Box

Anonymous — Wed, 02 Mar 2016 07:01:10 GMT

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

Re: Sorting order in Multi Box

bharatkishore — Wed, 02 Mar 2016 07:02:41 GMT

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

Re: Sorting order in Multi Box

Anonymous — Wed, 02 Mar 2016 07:04:16 GMT

Have the function always one selection there click there

Re: Sorting order in Multi Box

arulsettu — Wed, 02 Mar 2016 07:05:07 GMT

inline should be like this

LOAD * INLINE [

Choose a View

CSG

];

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

Re: Sorting order in Multi Box

Digvijay_Singh — Wed, 02 Mar 2016 07:07:06 GMT

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

Re: Sorting order in Multi Box

bharatkishore — Wed, 02 Mar 2016 07:09:29 GMT

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.

Re: Sorting order in Multi Box

arulsettu — Wed, 02 Mar 2016 07:09:37 GMT

mine is 11.20 SR 10

Re: Sorting order in Multi Box

bharatkishore — Wed, 02 Mar 2016 07:10:31 GMT

I have version QV11 SR12

Re: Sorting order in Multi Box

bharatkishore — Wed, 02 Mar 2016 07:10:47 GMT

I have done but not working...

Re: Sorting order in Multi Box

arulsettu — Wed, 02 Mar 2016 07:12:25 GMT

check the attachement

Re: Sorting order in Multi Box

Digvijay_Singh — Wed, 02 Mar 2016 07:13:59 GMT

I also have SR12, not sure, even I am not able to do it

Re: Sorting order in Multi Box

Chanty4u — Wed, 02 Mar 2016 07:15:26 GMT

same fr me am also usng SR12 only..not wrkng

Re: Sorting order in Multi Box

bharatkishore — Wed, 02 Mar 2016 07:16:46 GMT

Hi Arul,

Please find the image below and you have not selected always one selected value and the same problem and my requirement is OG should come first and OU should be always one selected value..

Re: Sorting order in Multi Box

arulsettu — Wed, 02 Mar 2016 07:18:29 GMT

Bharat Kishore ‌have u checked the file i uploaded

Re: Sorting order in Multi Box

bharatkishore — Wed, 02 Mar 2016 07:20:57 GMT

Yes..the image what i pasted is from your file only..

Re: Sorting order in Multi Box

arulsettu — Wed, 02 Mar 2016 07:23:31 GMT

let me update the version..