topic Re: Reg: Custom Sorting on Fields in the Columns in QlikView

Reg: Custom Sorting on Fields in the Columns

lakshmanvepuri — Tue, 24 Nov 2015 06:04:00 GMT

Hi,

Please help on the below request.

Table Name is Module

Column Name is ZONE

Data in the Zone is :

FRONT

BACK

NO DATA

POST

I am able to sort in Ascending or Descending order.

I want the sorting as given below.

FRONT

BACK

POST

NO DATA

Thanks a lot

Lakshman

Re: Reg: Custom Sorting on Fields in the Columns

effinty2112 — Tue, 24 Nov 2015 08:54:15 GMT

Hi Lakshman,

This is a good little tip for doing this:

Create a temporary table

TempTableToSetLoadOrder:

LOAD * INLINE [

ZONE

FRONT

BACK

POST

NO DATA

];

This sets the load order the way you want it.

At the end of the load script

DROP TABLE TempTableToSetLoadOrder;

The table might be dropped but QlikView has already set the load order of the field values.

In your charts set the sort order of the field ZONE to Load Order.

Regards

Re: Reg: Custom Sorting on Fields in the Columns

effinty2112 — Tue, 24 Nov 2015 08:56:51 GMT

Hi,

An other way to do it without changing the script is to set the sort order to the expression:

Match(ZONE, 'FRONT', 'BACK', 'POST, 'NO DATA')

Cheers

Re: Reg: Custom Sorting on Fields in the Columns

Mark_Little — Tue, 24 Nov 2015 09:07:42 GMT

Hi,

you can and ordering field on load.

Something like

IF(Field = 'FRONT', 1,

IF(Field = 'BACK', 2,

IF(Field = 'POST',3

IF(Field = 'NO DATA',4)

)

) As OrderNo,

Mark

Re: Reg: Custom Sorting on Fields in the Columns

tamilarasu — Tue, 24 Nov 2015 09:11:01 GMT

Hi Lakshmana,

Go to property and select sort tab.

Write the below in expression tab.

=Match(ZONE ,''FRONT' , 'BACK' , 'POST', 'NO DATA' )

Re: Reg: Custom Sorting on Fields in the Columns

NareshGuntur — Tue, 24 Nov 2015 09:26:14 GMT

Load * Inline [

ZONE, SORT

FRONT, 1

BACK, 2

POST, 3

NO DATA, 4

];

And under sorting in the front end, use the field "Sort" in Ascending order.

Cheers,

Naresh