Comparing week with actual week

[elenarelinque]

Hi!

I have data regarding the production of a factory. I want to know the amount of production running late. I need to show the production belonging to weeks prior to the current one.

I have tried like this:

=Sum({$<[Date.autoCalendar.Week]={<week((Today(0)), 0, 0 , 3)}>}[Production])

And this:

=If([Date.autoCalendar.Week]<Week((Today(0)), 0, 0 , 3),sum([Production]))

I explain the fileds:

Date.autoCalendar.Week: Is the field created by Qliksense using my field "Date"

Week((Today(0)), 0, 0 , 3): Is the function thet returns the actual week

Production: Is the field with the cuantity of production

[vinieme12 · Accepted solution]

Try

=Sum({$<[Date.autoCalendar.Week]={"<$(=week((Today(0)), 0, 0 , 3))"}>}[Production])

Or

=Sum(If([Date.autoCalendar.Week]<Week(Today(0), 0, 0 , 3),[Production]))

[elenarelinque]

It works! Thank you so much!