Date Range using variable in Set Analysis

[yashcena]

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! 🙂

[arulsettu]

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)

[Kushal_Chawda]

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)