topic Re: Sorting Problem in QlikView

Sorting Problem

svsudhakar — Mon, 01 Dec 2014 09:09:00 GMT

Hi,

I need help on the below customized sorting Order.

I have the data like this

RId Region

1 AAA

2 BBB

3 CCC

4 DDD

the transaction data is like this

Region val

AAA 50

BBB 100

CCC 200

But I want the output like below Order .

Region val

BBB 100

AAA 50

CCC 200

DDD 0

Re: Sorting Problem

jonathandienst — Mon, 01 Dec 2014 09:12:02 GMT

Use sort expression like this:

=Match(Region, 'BBB', 'AAA', 'CCC', 'DDD')

You could also preload them to set the load order, or use dual value and sort by number

HTH

Jonathan

Re: Sorting Problem

MarcoWedel — Mon, 01 Dec 2014 09:13:13 GMT

Sorting expression:

=Match(Region, 'BBB', 'AAA', 'CCC', 'DDD')

Re: Sorting Problem

alexandros17 — Mon, 01 Dec 2014 09:16:28 GMT

Load a table (with load * inline and for each region associate a number, then use that number to sort ...

load * inline [

Region, SortOrder

BBB,1

AAA,2

CCC,3

DDD,4

];

Use SortOrder in the expression sorting of your chart

let me know

Re: Sorting Problem

rajeshvaswani77 — Mon, 01 Dec 2014 09:18:04 GMT

Hi,

Left join the second table to first one.

Then have a dimension region and expression sum(

thanks,

Rajesh Vaswani

Re: Sorting Problem

svsudhakar — Mon, 01 Dec 2014 09:33:59 GMT

Hi ales,

I Created the Sort Order and given the sorting based on this field but here the problem is I don't have any transaction data for Region DDD ,even though I want to show in the output with 0 val.

because of this the DDD region sorting value not coming in my application.

Re: Sorting Problem

alexandros17 — Mon, 01 Dec 2014 09:52:49 GMT

So you mean that your expression will not retrieve any data for DDD Region?

In this case DDD will not appear in your chart ... if you want it to be displayed use show all data in dimension tab

Re: Sorting Problem

svsudhakar — Mon, 01 Dec 2014 11:03:26 GMT

Hi Alen,

Thanks for Your reply,

I have selected the show all data check box in dimension .now all the Regions are appearing but Sorting is not Working. Because there is no Associated data for DDD region