Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

deepika_gohil
New 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

Re: Sorting bar graph region wise

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

Community Browser