Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
deepika_gohil
Contributor
Contributor

Sorting bar graph region wise

Hi Community,

I am very new to Qlik and request your help in one of the issues I am facing. I have one bar graph populated region wise (north region, south region etc.). Unfortunately I am not able to sort this by North, East, West, South(NEWS). Can anyone help me with the solution.

Your help would be much appreciated!

1 Reply
kaushiknsolanki
MVP & Luminary
MVP & Luminary

HI,

There are couple of ways you can do this. The simplest one is as follows.

Go to Properties of the chart -> Sorting - > Drag and Drop Region field on 1st position -> Click on the drop down and Deselect the Auto sorting option -> Once you do this an option will be enabled which says "Sort by Expression"  -> Click on the checkbox and write below if statement.

If(Region = 'North', 1,

If(Region = 'East', 2,

If(Region = 'West', 3,

If(Region = 'South(News)', 4))))

And check on Sort "Ascending".

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".