order by on stack bar

[joeybird]

Hiya

is there an sort by expression that can be used on a stack bar in QLIK SENSE please?

i have a stack bar chart that counts the common products ordered by a customer.

but i want it to start with a specific product first. i don't want product names to order by alphabetic, descending or ascending , just start with product x e.g  "shoes" for all customers

please help

kind regards

joeybird

[JonnyPoole · Accepted solution]

i think so..

You can see the Skills (stack segments) are ordered by 'C','A','B' which is not alphabetical

on the right, i changed the sorting of 'Skills' to be 'custom' and then 'sort by expression'

The expression is

if(Skills='C',1,if(Skills='A',2,3))

and i sort that in 'ascending' order

[joeybird]

Hiya

that worked amazing!!!

also this works too

if(Product='Shoes',1,if(Product='A',2,3))

Thanx xx

Kind Regards

Joeybird