Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum based on dates

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

11 Replies
Not applicable
Author

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.