Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sort legend

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,

8 Replies
Clever_Anjos
Employee
Employee

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

PFA

Anonymous
Not applicable
Author

Most my tables have 2 dimensions

Clever_Anjos
Employee
Employee

You expect you legend having two dimensios plus a value?

Anonymous
Not applicable
Author

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
Employee
Employee

PFA

Anonymous
Not applicable
Author

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
Employee
Employee

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

Only straight table can do that

Anonymous
Not applicable
Author

Thanks for your helping