Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!