Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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