4 Replies Latest reply: Jan 9, 2018 7:56 AM by Balaji SJ RSS

    Building chart with selected year and previous year

    Balaji SJ

      Hi People

       

      I have a requirement to compare sales of selected year and previous year.

       

      I have used this expression to show previous year data,

      =Sum({$<acc_period_year={"$(=acc_period_year-1)"}>}bill_size)

       

      When i select a single year, the chart is displayed.

      qlik issue1.PNG

       

      But when i select 2 years in filter pane, the chart (previous year) is not working.

      qlik issue2.PNG

       

      Please let me know the expression which i could use to display previous year (even when more years are selected).

       

      Thanks

      Balaji