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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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