Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
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