11 Replies Latest reply: Jun 16, 2017 4:41 AM by Sunny Talwar RSS

    Sum based on dates

    Linus Andersson



      I have a file containing, among other things, a date field (2017-06-14) and another field containing sales number.

      I would like to summarize sales per month as in the example below, summing May and June separately.



      I have tried to create dimensions with wildmatch but I can not use that dimension as a field.



      Do you have any suggestions?


      This is true of Qlik sense desktop





      Date                     Sales

      2017-05-01            1526

      2017-05-02            1236

      2017-05-25            548       

      2017-06-02            485

      2017-06-05            2699