Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
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
Author

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
Author

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