topic Re: Lastest week count in QlikView

Lastest week count

Abhi999 — Tue, 25 Aug 2020 01:11:18 GMT

Could some one help me on below query.

I want to count of orders weekly based on max in date field.

tresB — Tue, 25 Aug 2020 05:42:40 GMT

You have given not much information. With that; you may try something like:

Dim : Week

Exp : FirstSortedValue(Aggr(Count(Distinct OrderID), Week, Date), -Date)

Abhi999 — Tue, 25 Aug 2020 06:50:46 GMT

Hi Tresesco, I am using KPI to show latest week , based max available date.

Ex: I have data only upto last Monday, so I want calculate orders of last week.

tresB — Tue, 25 Aug 2020 06:57:26 GMT

If you have a week field(if you don't, create it in the script using week()), you can try like:

Count({<Week={'$(=Max(Week))'}>}OrderID)