# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

## 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

## 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

Valued Contributor

## Re: Number of entries in the current week

New Contributor II

## Re: Number of entries in the current week

Hi , thanks it worked