Lastweek

[soniasweety]

Hi all,

I have a data sample attached.

I want to calculate  the  current week count of value and last week count of value.

I have a date field . 

here two conditions : 1  if week starts from Monday to sunday how can I calculate the count   each item wise?

2. if week starts from sunday to Saturday how to caluculate In script?  

Can anyone give some idea on this?

Thanks

Sony

[antoniotiman]

You need to select WeekNumber 28

or

Count({<WeekNumber={'$(=Max(WeekNumber))'}>} DISTINCT ID)

[magdalenatudose]

Hi,

Can someone to atash me an simple example (for Qlik Sense) who resume this conversation?

I don't know how i can applique your advices to show the value from last week.

Thank you,

Magdalena