Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Sorting Problem

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

Tags (1)
7 Replies
Highlighted
MVP
MVP

Re: Sorting Problem

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted

Re: Sorting Problem

Sorting expression:

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

Highlighted

Re: Sorting Problem

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

Highlighted
Specialist III
Specialist III

Re: Sorting Problem

Hi,

Left join the second table to first one.

Then have a dimension region and expression sum(

thanks,

Rajesh Vaswani

Highlighted
Creator
Creator

Re: Sorting Problem

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.

Highlighted

Re: Sorting Problem

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

Highlighted
Creator
Creator

Re: Sorting Problem


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