4 Replies Latest reply: Aug 6, 2018 3:58 AM by Novice Qlik RSS

    sorting quarter and year values on a line chart

    Novice Qlik

      Hi all,

       

      I am trying to sort quarter and year values on the x-axis on a line chart. Eg. q1-2017, q2-2017, q3-2017, Q4-2017, Q1-2018, etc

       

      In my csv file I have two different fields for both quarters (q1, q2, q3, q4) and a year field for respective quarters (2016, 2017, 2018 etc)

       

      I have already combined the fields in Qlik sense by Quarter_Value&'-'&Year in the line chart

       

      Can anyone help please?