topic Re: Sorting y axis in graph in QlikView

Sorting y axis in graph

Mon, 14 Sep 2015 05:41:32 GMT

I have ranges as shown in the attachment.

I want to sort it in y axis as :-

More than 1000k

500 to 1000k

200k to 500k

100k to 200k

Less than 100k

Note :- Without any hard coding.

Re: Sorting y axis in graph

Mon, 14 Sep 2015 05:43:04 GMT

Hi,

Go for Sort tab and give the expression sorting in descending order.

Re: Sorting y axis in graph

Mon, 14 Sep 2015 05:43:22 GMT

Hi,

Can u share your qvw.

Re: Sorting y axis in graph

manojkulkarni — Mon, 14 Sep 2015 05:45:22 GMT

How did you derived Ranges ? If it by expression, then use the same expression in Sorting as well.

Possible share the application

Re: Sorting y axis in graph

Mon, 14 Sep 2015 05:47:30 GMT

Nope it didnt worked

I am not permitted to share the qvw, Sorryyy

Re: Sorting y axis in graph

sunny_talwar — Mon, 14 Sep 2015 05:48:43 GMT

May be use a dual function to create your ranges. What expression are you using for your dimension right now?

Re: Sorting y axis in graph

Mon, 14 Sep 2015 05:49:08 GMT

Can you create a sample qvw with some sample data.

Re: Sorting y axis in graph

Mon, 14 Sep 2015 05:49:16 GMT

Its a field X from DB and I'm directly fetching that field.

I am not creating any ranges in qlikview.

Re: Sorting y axis in graph

sunny_talwar — Mon, 14 Sep 2015 05:50:29 GMT

What function are you using for creating the ranges in the script? or are these coming directly from your datasource?

Re: Sorting y axis in graph

Mon, 14 Sep 2015 05:51:39 GMT

Its a field from DB, say X field.

ranges are its values, I am not creating any ranges in qlikview.

Re: Sorting y axis in graph

Mon, 14 Sep 2015 05:53:46 GMT

yep, you are ryt 🙂 , This is a field directly from datasource, ranges are its values

say 'X' field from Datasource and its values are these ranges.

Re: Sorting y axis in graph

Mon, 14 Sep 2015 05:58:53 GMT

Hi Try like this

Put load order based on y axis that you using as a dimension

Re: Sorting y axis in graph

sunny_talwar — Mon, 14 Sep 2015 06:06:58 GMT

I suggest using Dual function in your script to create numeric values for your fields. For the sample provided, this script should work fine:

Table:

LOAD Field,

Dual(Field, Alt((Num#(KeepChar(SubField(Field, ' ', 1), '0123456789'), '##') + Num#(KeepChar(SubField(Field, ' ', -1), '0123456789'), '##'))/2,

KeepChar(Field, '0123456789'))) as NewField;

LOAD * Inline [

Field

More than 1000k

500 to 1000k

200k to 500k

100k to 200k

Less than 100k

];

Where NewField looks like your ranges, but they also have associated value with them which can then be sorted in ascending or descending values

Re: Sorting y axis in graph

sunny_talwar — Mon, 14 Sep 2015 06:15:07 GMT

Chart would look like this:

Re: Sorting y axis in graph

Mon, 14 Sep 2015 06:38:00 GMT

Yeah its working,

Thank you Sunny 🙂

Re: Sorting y axis in graph

sunny_talwar — Mon, 14 Sep 2015 06:40:17 GMT

Awesome

I am glad it is working the way you wanted

Best,

Sunny

Re: Sorting y axis in graph

Mon, 14 Sep 2015 06:43:44 GMT

Yeah, its working as I expected.

Thanks much Sunny