1 Reply Latest reply: Jan 24, 2018 2:54 AM by Kaushik Solanki RSS

    Sorting bar graph region wise

    Deepika Gohil

      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!

        • Re: Sorting bar graph region wise
          Kaushik Solanki



          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".



          Kaushik Solanki