Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik_ULG
Creator
Creator

Dynamic calculation for previous 8 days

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.

2 Replies
vishsaggi
Champion III
Champion III

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
Creator
Creator
Author

That is exactly it.


Thanks very much Nagaraju.