Custom sort order bar chart

[CasperQlik]

Hi Qlik Community

Is it possible to sort a bar char in a way, where I "pin" a specific value either at the first or last position on the chart and then sort the remaining values by count etc.

My dim is "Category" and my Measure is "count(id)".

I'd like where id = 28 to be "pinned" at the either end of the chart and then sort the remaining categories by count descending. Hope it makes sense.

Any help is appreciated. 

Casper

[yunus_emre]

Hi @CasperQlik,

You can use like =If(id=28, -1, count(id)) in the sort expression.

I hope it works