Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have monthly ticket data in my data model.
Every month there is a release (different release date for every month), I need to show the ticket count 7 days before the release and 7 days after the release
I'm able to show the overall ticket count before and after release. However I want only +/- 7days from release ticket count.
I have created 3 variables:
vPrevDays = date(RELEASE_DATE-7, 'MM/DD/YYYY')
vRelDate = date(RELEASE_DATE, 'MM/DD/YYYY')
vNext7Days = date(RELEASE_DATE+7, 'MM/DD/YYYY')
However, I'm not able to write the set analysis syntax correctly
I have attached a sample qlikview file here. Any help would be appreciated! 🙂
Maybe like this
preivious-
sum({<RELEASE_DATE={'$(=date(max(Date(RELEASE_DATE))-7, 'MM/DD/YYYY'))'}>}CASE)
After
sum({<RELEASE_DATE={'$(=date(max(Date(RELEASE_DATE))+7, 'MM/DD/YYYY'))'}>}CASE)
try
Before-
sum({<RELEASE_DATE={'>=$(=date(max(RELEASE_DATE)-7))<=$(=date(max(RELEASE_DATE)))'}>}CASE)
After-
sum({<RELEASE_DATE={'>=$(=date(max(RELEASE_DATE)))<=$(=date(max(RELEASE_DATE)+7))'}>}CASE)