Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
clifford
Contributor II
Contributor II

Rank the past week of sales out of the past year

Hello, I'm looking to show only the past week of sales dates while showing the rank of that day's sales out of the past year. However when I limit the dimension to only show the past week it only ranks it out of five. Is there a way to only show the past week but still show the rank from the past year?

The sales dates I want to show:

clifford_0-1698069582871.png

How I want the ranks to look:

clifford_1-1698069663578.png

Current Dimension:

=if((weekname(sales_date)=weekname(now()-7)) and (weekday(sales_date)<5),sales_date)

Current Measure:

=Rank(sum({<sales_date={">=$(=vPastThreeMonthStartDate)<=$(=vMaxDatePastWeek)"}>}net_sales))

Thanks for you're help!

Labels (1)
0 Replies