Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Time measure

Trying to get a measure that will sum sales for the month to day.  So far I have the following expression, but it does not work:

(sum(aggr(sum(distinct{$<[completed_date.autoCalendar.Date]={">=$(=Date(max([completed_date])-30))"}>}(order_total)), order_id))

Instead, I get a rolling thirty day total.  Any idea on how to get this to show Current MTD sales?

Also, probably very similar to that measure, I need to create a measure that will Sum last full week of sales:

(sum(aggr(sum(distinct{$<[completed_date.autoCalendar.Date]={"$(=Date(max([completed_date])-7))"}>}(order_total)), order_id))

not really working either.  Any help is appreciated.  Thanks in advance.

0 Replies