topic Re: Sorting X Axis variable in QlikView

Sorting X Axis variable

ts3st1000 — Wed, 25 Nov 2020 16:16:04 GMT

Hello, I need to sort the x axis on a chart where the variable takes one of these 5 values:

Alpha, Beta, Gamma, Not Applicable, or None. And i tried the following in "Sorting by Expression" field:

if(Variable='Alpha',1,if(Variable='Beta',2,if(Variable='Gamma',3,if(Variable='Not Applicable',4,5))))

but this has not given me the expected result. Any suggestions how to fix this please.

Thanks and regards,

Re: Sorting X Axis variable

neha_shirsath — Thu, 07 Dec 2017 11:12:09 GMT

For better sorting purpose you can just create Inline like-

Load * inline [

Variable, No

Alpha,1

Beta,2

Gamma,3,

Not Applicable,4,

];

Sort your expression by No field.

Re: Sorting X Axis variable

Anil_Babu_Samineni — Thu, 07 Dec 2017 11:39:03 GMT

Use Dual() to get into work..

Re: Sorting X Axis variable

ts3st1000 — Thu, 07 Dec 2017 11:58:25 GMT

Thanks Neha, you mean that part has to go under the Data Load Editor ? ... sorry i am very new to Qlik

Re: Sorting X Axis variable

neha_shirsath — Thu, 07 Dec 2017 12:01:32 GMT

Ok not an issue

In your Edit Script add this Inline table.

Or provide me some sample data.

Re: Sorting X Axis variable

big_dreams — Thu, 07 Dec 2017 12:04:05 GMT

Another possible solution is

In sorting tab write expression

match(fieldName,'Aplha','Beta','Gamma','Not Applicable')

Regards,

Re: Sorting X Axis variable

ts3st1000 — Thu, 07 Dec 2017 12:37:38 GMT

Thanks again Neha. Unfortunately, i can not put real data in here due to confidentiality.

I have something like this in the Data Load Editor, and I added your code at the bottom, but it did not work.

-----------------------

Table

Load

Variable

SQL select

Variable

From Table

---------------------------

Load * inline [

Variable, No

Alpha,1

Beta,2

Gamma,3,

Not Applicable,4,

];

------------------

Any suggestions please how to fix it? what is the meaning of that No after Variable ? Thanks very much.

Re: Sorting X Axis variable

neha_shirsath — Thu, 07 Dec 2017 12:45:06 GMT

Yes this code is ok.

Now go to front end in your chart/table where you want sorting, in that in sorting tab add the field No .

This will sort variable field according to what result you want.

Re: Sorting X Axis variable

trdandamudi — Thu, 07 Dec 2017 12:48:40 GMT

One more way is as below:

in Sort expression use the following:

Pick(Match(Variable,'Alpha','Beta','Gamma','Not Applicable','None'),1,2,3,4,5)

Re: Sorting X Axis variable

ts3st1000 — Thu, 07 Dec 2017 14:17:12 GMT

Thanks Neha, but i still got an error when i loaded the data. I guess this make sense more to me as i increase my knowldge of qlik. Any good reference you would suggest please, other that this forum. Thank you.

Re: Sorting X Axis variable

ts3st1000 — Thu, 07 Dec 2017 14:17:55 GMT

Thank you very much Thirumala, that worked.

Re: Sorting X Axis variable

trdandamudi — Thu, 07 Dec 2017 14:24:11 GMT

You are welcome and glad able to help.

Re: Sorting X Axis variable

MarcoWedel — Thu, 07 Dec 2017 21:04:51 GMT

Hi,

if this expression works, then

Match(Variable,'Alpha','Beta','Gamma','Not Applicable','None')

should deliver the same result, as the Match() function itself already returns those numbers.

hope this helps

regards

Marco

Re: Sorting X Axis variable

neha_shirsath — Fri, 08 Dec 2017 04:27:35 GMT

Yes, what i was explaining for Inline was exactly given in qvw by trdandamudi