6 Replies Latest reply: Mar 24, 2018 12:57 PM by Petter Skjolden RSS

    Derive MonthWeek field from the date

    rajiv krishna

      Hi All,

       

      I have Date field and I want to create Line Chart in qlik sense.

       

      Dimension:  "Monthweek"-(MMMW1 )

       

      Measures:1.Current year Sales

                        2.Previous Year sales

       

       

       

      And also want to achieve Proper Month week sort order in Chart

       

       

      can some one suggest the best way to achieve this.

       

       

      Thanks,

      Raj