Qlik Community

Ask a Question

Qlik Sense App Development

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

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ismqui00
Contributor III
Contributor III

Sum Week

Working on a measure that would show me total sales from last full  week based on todays date.  So far I have this expression but it is not functioning: 

sum(aggr(sum(distinct{$<[completed_date.autoCalendar.Week]={"$(=Week(Today(1) )"}>}(order_total)), order_id))

Any help on with this expression is appreciated.  Thanks in advance

4 Replies
sunny_talwar

May be because you are missing a parenthesis

Sum(Aggr(Sum(DISTINCT {$<[completed_date.autoCalendar.Week] = {"$(=Week(Today(1)))"}>} order_total), order_id))

ismqui00
Contributor III
Contributor III

Made that change, but still not functioning.  Thanks though, probably not going to hurt to have the correct amount of parenthesis in espression.

sunny_talwar

Can you show the script for the derived calendar?

ismqui00
Contributor III
Contributor III

Not sure how to do that, maybe I don't have access to it?