1 Reply Latest reply: Feb 8, 2018 11:48 AM by Sunny Talwar RSS

    Problems showing Prev month sales.

    Tomás Menazzi

      Hi.

      I'm new in Qlik sense.

      I need to show this

       

      2018-01Previus MonthForecast
      Admin

      30

      25

      32
      Seller 1334045
      Seller 2433540

      I use Sql server Via Oledb, I have Date, Year, Month and cuantity fields in my query.

      I try defining variables on the script section and use a measure

      The variables have allredy been Checked.

      Sum({<Year={"$(=Max(Year))"}, YearMonth={"<=$(=vPriorMonthYear)"}, Year=,Month=>}Cuantity)

       

      On a pivot Table. But I always recieve the same values on "2018-01" and Previus Month columns.