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

    Sum based on dates

    Linus Andersson

      Hello,

       

      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