Sum based on dates

[#1]

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

[#2]

Hello, I found Another way to sum by date that works.

sum(if(wildmatch(Date,'2017-05*'),Sales))

[sunny_talwar]

That is great, but I encourage you to use set analysis rather then if statement because set analysis is more efficient in carrying out these operations compared to if statements.