Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
AndrewMcIlwrick
Partner - Specialist
Partner - Specialist

Colors and Legend Ordering

colors.jpg

 

 

 

As per screenshot, by using custom colours for a chart (by creating a master dimension and assigning colours to each dimension) messes with the ordering of the Key I want it to be in a specific order. I use the below sorting expression however it does not affect the key.

Match([Coverage Group (All)],'Short','Med','Long','Very Long','Dead Stock','NYA','Cat 0')

Labels (1)
2 Replies
y_grynechko
Creator III
Creator III

Hey, 

Add dual value to the dimension or add additional dimension like this in the load script: 

if([Coverage Group (All)], ='Short', 1,

if([Coverage Group (All)], ='Med', 2)) as Sort (add more ifs) 

After doing this you can use the Sort field to Sort the bar chart. 

ksharpes
Creator
Creator

Hello,

This still does not affect the Legend sorting unfortunately.