Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rish
New Contributor II

Number of entries in the current week

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.

1 Solution

Accepted Solutions
Partner
Partner

Re: Number of entries in the current week

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

3 Replies
Partner
Partner

Re: Number of entries in the current week

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

Highlighted
dwforest
Valued Contributor

Re: Number of entries in the current week

rish
New Contributor II

Re: Number of entries in the current week

Hi , thanks it worked