topic Re: Re: Re: Sort legend in QlikView

Sort legend

Anonymous — Wed, 22 Jan 2014 17:05:42 GMT

Hi community,

Is possible sort legend by Y value and the last should be 'Other' tag?

For example

Variable1

A=39%

B=35%

C=20%

D=15%

Other=23%

Match(Variable1,'A','B',...'Other') doesn't help, because A, B, C will be different each time.

Thanks,

Clever_Anjos — Wed, 22 Jan 2014 17:20:05 GMT

One option is put a straight table (not total row, no caption) with Dimension Limit properly set right above your graph.

PFA

Anonymous — Wed, 22 Jan 2014 17:39:14 GMT

Most my tables have 2 dimensions

Clever_Anjos — Thu, 23 Jan 2014 11:07:47 GMT

You expect you legend having two dimensios plus a value?

Anonymous — Thu, 23 Jan 2014 14:33:41 GMT

Please see my attached file.

When I sort by Y value, my Months are sorted wrong.

I'd like Purpose of visit will be sorted by Y-value and the last Other specify and Months go in right order.

Any suggestion?

Clever_Anjos — Thu, 23 Jan 2014 15:08:24 GMT

PFA

Anonymous — Thu, 23 Jan 2014 15:30:28 GMT

It resolved sort by Y-value with Months right order

thank you so much.

You don't know how to set up Other specify in the last row in the table?

Clever_Anjos — Thu, 23 Jan 2014 16:21:13 GMT

You´re using Pivot Table, that does not support Dimension Limits.

Only straight table can do that

Anonymous — Thu, 23 Jan 2014 16:45:29 GMT

Thanks for your helping