topic Re: sort issue in legend in QlikView

sort issue in legend

Wed, 14 Jan 2015 09:47:28 GMT

Hi All,

I have pie chart and have ageing in legend which is in assorted manner. i want to sort it in ascending.

Any help would be appreciated

PFA

Re: sort issue in legend

alexandros17 — Wed, 14 Jan 2015 09:52:35 GMT

What about age band? How have you grouped data? By Rank function?, With if condition?

Let me k now

Re: sort issue in legend

Wed, 14 Jan 2015 09:53:06 GMT

Hi Sruti,

I would say load your age band field as a dual, so that each underlying band has a numerical value you can base your sort on.

Hope that helps

Joe

Re: sort issue in legend

Wed, 14 Jan 2015 10:01:52 GMT

HI Saccone,

I grouped data with if condition

Re: sort issue in legend

alexandros17 — Wed, 14 Jan 2015 10:07:08 GMT

So use the same if condition in the sort ... if(data>0 and data <30, 1, if(data>xx and data < yy,2 .... )

let me know

Re: sort issue in legend

jzimolong — Wed, 14 Jan 2015 11:13:12 GMT

Add the following to your load script, then sort the field in legend by "Load order". Just make sure in below, the "AgeBand" corresponds to your field name.

AgeBand_SortOrder:
Load * Inline [
AgeBand
0-30 Days
31-60 Days
61-90 Days
91-120 Days
121-150 Days
151-180 Days
181+ Days];