topic Re: Custom sorting in QlikView

Custom sorting

n1ef5ng1 — Tue, 06 Aug 2013 07:37:58 GMT

Hi all,

I have this Region Code field name 10,20,30,40,50,61,62,70,81,82

I would like it to sort in this order in one of my particular report, 10,20,30,50,61,62,40,82,81

I tried using Match, WildMatch on Sort -> Expression but it does not work

I am not able to edit any scripting pertaining to this problem I am facing

Is there any way I can do this custom sorting

Thanks

Re: Custom sorting

CELAMBARASAN — Tue, 06 Aug 2013 07:48:46 GMT

Did you tried with sort by expression option and expression as

Match(RegionCode,10,20,30,50,61,62,40,82,81)

It will works. if not can you share the sample file?

Or use Load order

Before loading your data table you have to use inline load first as

LoadOrder:

Load * Inline [

RegionCode

81];

Re: Custom sorting

n1ef5ng1 — Tue, 06 Aug 2013 08:53:08 GMT

you are right. however I just realized the main cause of my problem is that I want to sort calculated dimension instead of normal dimension; if is normal dimension i would be able to use match, any body can solve this issue

Re: Custom sorting

CELAMBARASAN — Tue, 06 Aug 2013 08:56:04 GMT

Calculated dimension based on what criteria?

Re: Custom sorting

Kushal_Chawda — Tue, 06 Aug 2013 09:42:58 GMT

Create inline table in order you want to sort

in your case as below

load * inline [

RegionCode, Sort

10,1

20,2

30,3

50,4

61,5

62,6

40,7

82,8

81,9 ];

Now go to chart properties>sort tab in expression use Sort filed