RangeCount Distinct? Not possible in Qlik Sense?

SDT — Tue, 27 Apr 2021 16:00:48 GMT

I have data that includes the fields

OrderNumber
InvoiceDate
ProductID

I created a chart using WeekEnd(InvoiceDate) as the dimension and Count(Distinct ProductID) as the measure to see how many unique products are sold per week. Simple.

Now I want to know how many unique products were invoiced in a 12 week rolling period and report that each week. Essentially on the same chart add the unique count of products for the prior 12 weeks.

I have tried various rangecount, aggr, etc and cannot get it working. If only Rangecount had a distinct option.

Does any one have a suggestion on how to prepare that visual?

Re: RangeCount Distinct? Not possible in Qlik Sense?

jwjackso — Tue, 27 Apr 2021 20:15:13 GMT

I use Henric's The-As-Of-Table for rolling period calculations. Your weekly count would be something like Count({<DayDiff={"<7"}>} Distinct ProductID) and the rolling 12 count would be Count({<DayDiff={"<84"}>}Distinct ProductID)

topic RangeCount Distinct? Not possible in Qlik Sense? in App Development

RangeCount Distinct? Not possible in Qlik Sense?

Re: RangeCount Distinct? Not possible in Qlik Sense?