Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joeybird
Contributor II

order by on stack bar

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

1 Solution

Accepted Solutions
Employee
Employee

Re: order by on stack bar

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

Capture.PNG

2 Replies
Employee
Employee

Re: order by on stack bar

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

Capture.PNG

joeybird
Contributor II

Re: order by on stack bar

Hiya

that worked amazing!!!

also this works too

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

Thanx xx

Kind Regards

Joeybird