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

          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