how show Value when Enter number of days in it

[nazaninslp]

Dears

I want to create an input box (for days) that when I enter for example 45, my revenue table should show the revenue of the last 45 days.

expression of table : sum({<Area_Category-={"Test","Free ShortCode","Xtratime","ACS"}>}REVENUE)

dimension of table : date_key , Area_Category

would you please help me in this regards?

[Melissa_Potvin]

are you working with QlikView or Qlik Sense?

[nazaninslp]

DEAR Melissa
I'm working with Qlikview

[Melissa_Potvin]

Thank you, I am moving your post to the QV forum.

[passionate]

You can create a flag in master calendar to find days ago.

Refer 

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130   

for As of Date flag.

And use variable in input box.

[nazaninslp]

Dear Passionate
Link is not working...(An invalid set of parameters has been specified in the url.)
I didn't get completely, would you please clarify more?

[passionate]

Search on google

As of calendar qlikview by HIC

[akshaye_c_navale]

Hey,

You may try below expression,

sum({<Area_Category-={"Test","Free ShortCode","Xtratime","ACS"},Date={">=$(=DATE(MAX(Date)-iDays))<=$(=DATE(MAX(Date)))"}>}REVENUE)

Here, iDays is input box variable , Date is date field in data model

Thanks..