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: 
nazaninslp
Contributor III
Contributor III

how show Value when Enter number of days in it

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?

Labels (3)
7 Replies
Melissa_Potvin
Community Manager
Community Manager

are you working with QlikView or Qlik Sense?
nazaninslp
Contributor III
Contributor III
Author

DEAR Melissa
I'm working with Qlikview
Melissa_Potvin
Community Manager
Community Manager

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

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
Contributor III
Contributor III
Author

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
Specialist
Specialist

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..