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?