topic Re: Expression help in QlikView

Expression help

Tue, 09 Dec 2014 05:21:03 GMT

Hi all,

I have a list of alphabetical and numerical values in axis. like this

A C C E F FL HO 1 2 3 4 5 10 .. I need to sort it like this E A 1 2 3 4 5 10 FL HO. Please look at the screenshot for more clarity.

Thanks in Advance

Sai.

Re: Expression help

its_anandrjs — Tue, 09 Dec 2014 05:39:03 GMT

Hi,

If there is few values you can try this way write expression in the Sort properties >> Sort Expression

Match( FieldName, 'E', 'A' ,'1' ,'2' ,'3' ,'4',' 5' ,'10' ,'FL' ,'HO')

And unselected all option

Regards

Anand

Re: Expression help

sarfaraz_sheikh — Tue, 09 Dec 2014 06:22:23 GMT

you need to put your sort order into the expression defination of sort tab....try like below

WilMatch(FieldName ,E', 'A' ,'1' ,'2' ,'3' ,'4',' 5' ,'10' ,'FL' ,'HO' so on......)

Regards

Sarfaraz

Re: Expression help

aveeeeeee7en — Tue, 09 Dec 2014 06:30:36 GMT

Right Click on Chart > Go to Properties > Sort > Check Expression > Write this Expression > Dual(YourFieldName,Match(YourFieldName,'E','A','1','2','3','4','5','10','FL','HO'..........)) > Ascending.

This expression will sort the way you want.

Regards

Av7eN

Re: Expression help

Tue, 09 Dec 2014 06:51:25 GMT

Thanks All .