Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
GSmith
Contributor
Contributor

Comparative, Cumulative order by week, resetting at year end

Hi,

Just started with Qlik, I'm trying to create a bar chart comparing cumulative orders by week in the last 3 years.

It needs to reset the count on the last day or first day of the year

The date range and comparison I have sorted out already.

The problem I have is getting the cumulative count to work properly.

it needs to give a distinct count of customers - so once they have placed an order in (for example) week 1, they should not be counted in any of the later weeks. But this should reset in Week 1.

This is where I have got to so far:

=if(Week(Date)=1,0,

RangeSum(Above(TOTAL count({<year,month,week, DateField = {"<$(=maxstring(DateField))"},DateType={[Cust.]}> } distinct [Cust.] ), 0, RowNo(TOTAL)))

)

Any advice would be appreciated, thanks - I fully expect I'm quite a way out here!

Labels (4)
0 Replies