topic Dynamic calculation for previous 8 days in QlikView

Dynamic calculation for previous 8 days

Qlik_ULG — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Dynamic calculation for previous 8 days

vishsaggi — Tue, 11 Sep 2018 14:33:47 GMT

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)

Re: Dynamic calculation for previous 8 days

Qlik_ULG — Tue, 11 Sep 2018 14:38:24 GMT

That is exactly it.

Thanks very much Nagaraju.