topic Re: order by on stack bar in App Development

order by on stack bar

joeybird — Tue, 12 May 2015 18:57:48 GMT

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

Re: order by on stack bar

JonnyPoole — Wed, 13 May 2015 00:57:49 GMT

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

Re: order by on stack bar

joeybird — Wed, 13 May 2015 07:17:36 GMT

Hiya

that worked amazing!!!

also this works too

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

Thanx xx

Kind Regards

Joeybird