Number of entries in the current week

[rish]

Hello, what would be the expression to calculate the number of entries made in the current week and also last week? I cant use a static value for week as the data I am dealing with is updated everyday. Thanks.

[dplr-rn · Accepted solution]

Use set analysis

e.g. 

Sum({<OrderDate={">=$(=weekstart(today())) <=$(=weekend(today()))"}>}Sales) - current week

Sum({<OrderDate={">=$(=weekstart(today()-7)) <=$(=weekend(today()-7))"}>}Sales) - previous week

[dwforest]

Check out the inweek function 

https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeFun...

[rish]

Hi , thanks it worked