Dynamic calculation for previous 8 days

[Qlik_ULG]

Hi,

I am looking to create an expression to show a count of projects that were Shipped over a number of previous days. I also have to include Set Analysis to only include certain Projects that should be counted.

How would I set this up in an expression?

Currently I am using this calculation, but need to include a date filter to only show the previous 8 days from today

count({<[Project_Status_ID] = {10}>} Job_ID)

Thanks in advance.

[vishsaggi]

May be this? Make sure your Today() function displays same format as your date field. My current system date format is MM/DD/YYYY so if it is the same then you can use the below expr as is. If your format is DD/MM/YYYY then you have to add formatting to your Today() like

Date(Today()-8, 'DD/MM/YYYY')

= count({<[Project_Status_ID] = {10}, DateField = {">=$(=Date(Today()-8))"} >} Job_ID)

[Qlik_ULG]

That is exactly it.

Thanks very much Nagaraju.