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 clifford_0-1698069582871.png](https://community.qlik.com/t5/image/serverpage/image-id/118733iFCC9FAAE4BC6EEBA/image-dimensions/497x81?v=v2)
How I want the ranks to look:
![clifford_1-1698069663578.png clifford_1-1698069663578.png](https://community.qlik.com/t5/image/serverpage/image-id/118735i8BEFB4028BEF9511/image-dimensions/485x186?v=v2)
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!