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.
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 If reply is satisfactory, please "Like" the post. If reply is solution, please mark as "Correct".