topic Re: Sorting current selection by ABC in QlikView

Sorting current selection by ABC

Tue, 20 Aug 2013 14:14:47 GMT

Hi,

I have the following problem.

How do I sort current selection by ABC?

Please see in the example attached

I have companies NOT sorted by ABC.

Please help me how I can sort it.

Thanks,

Inna.

Re: Sorting current selection by ABC

Tue, 20 Aug 2013 14:19:25 GMT

Hi,

Is it a list box?

Re: Sorting current selection by ABC

Anonymous — Tue, 20 Aug 2013 14:22:52 GMT

have you checked sort-text-desc?

Re: Sorting current selection by ABC

Tue, 20 Aug 2013 14:24:51 GMT

I dont know at whiche objects you can do it but I'm sure you can do it by Listboex and Multibox.

Go to properties then Sort and checke "State"

Re: Sorting current selection by ABC

Sun, 25 Aug 2013 08:13:17 GMT

Hi Anutosh,

it is a multibox.

In properties I have sort->state->descending.

It does not help. It helps for other dimensions , but not for this one.

Thanks,

Inna.

Re: Sorting current selection by ABC

Mon, 26 Aug 2013 06:53:04 GMT

Anybody can help me?

Re: Sorting current selection by ABC

narender123 — Mon, 26 Aug 2013 07:17:27 GMT

Hi,

Share your data.

Re: Sorting current selection by ABC

Mon, 26 Aug 2013 07:20:04 GMT

Hi attached print screen to show how it looks.

What else do you need?

Sample model can help?

Re: Sorting current selection by ABC

tresB — Mon, 26 Aug 2013 07:28:53 GMT

In general, it should be combination of two sort types, State(Autoascending) and Text(A->Z), if that is not working, your data might have some issues. If you can share sample app, can be checked.

Re: Re: Sorting current selection by ABC

narender123 — Mon, 26 Aug 2013 07:33:49 GMT

Hi,

Please see the attached screen shots,

I have only do in sort>Text>Z to A

Thanks

Re: Re: Sorting current selection by ABC

Mon, 26 Aug 2013 08:30:47 GMT

Hi,

I have sort->state->autoascending->Text->a->z.

In my big model it does not work for company.

BUT in sample model I built for you- for one day only it WORKS.

Very strange.

What can I do anyway?

Can i debug it in some way?

Thanks,

Inna