Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
vovan4ik
Specialist II
Specialist II

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

vovan4ik
Specialist II
Specialist II

Most my tables have 2 dimensions

Clever_Anjos
Employee
Employee

You expect you legend having two dimensios plus a value?

vovan4ik
Specialist II
Specialist II

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

vovan4ik
Specialist II
Specialist II

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

vovan4ik
Specialist II
Specialist II

Thanks for your helping