7 Replies Latest reply: Jul 23, 2018 12:40 PM by Thiago Justen Teixeira RSS

    Sum Sales by month

    Belguith Chachia

      Hello,

      I'm using QlikSens Desktop

      I want to create KPI visualisation whith show total SALES for the current month.

       

      I Created a variable currentMonth = Month(today())

       

      currentMonth value = juil.

       

      currentMonthTotalSales = Sum({< [DateCmd_PK-Date_PK.autoCalendar.Month]  = {'juil.'}> } Total_HT)  ---> WORKS


       

      currentMonthTotalSales = Sum({< [DateCmd_PK-Date_PK.autoCalendar.Month]  = {currentMonth}> } Total_HT)  DOES NOT WORKS



      I also Tried


      currentMonthTotalSales = Sum({< [DateCmd_PK-Date_PK.autoCalendar.MonthRelNo]  = {6}> } Total_HT)  --> this does not work also


      could some one help me on this issue please ?