11 Replies Latest reply: May 11, 2016 9:12 AM by Silambarasan Manickam RSS

    Previous month vs Current Month in Qlik sense

    scotly victor

      Hi Qlikers,



      I wanted to show line Chart  for Previous month and current month for dimension :Month-> Day

      Expression for current month 

      =sum({<type={'Order'},FiscalYear={$(=max(FiscalYear))}>} Sales)

      Current Month works fine


      Expression for Previous month

      =sum({<type={'Order'},FiscalYear={$(=max(FiscalYear))},MonthID={$(=max(MonthID)-1)}>} Sales)

      It Showing Wrong output


      Can anyone help me?