Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
nazaninegogo
New 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
Community Manager
Community Manager

Re: how show Value when Enter number of days in it

are you working with QlikView or Qlik Sense?
nazaninegogo
New Contributor III

Re: how show Value when Enter number of days in it

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

Re: how show Value when Enter number of days in it

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

Re: how show Value when Enter number of days in it

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.

 

 

nazaninegogo
New Contributor III

Re: how show Value when Enter number of days in it

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
Valued Contributor

Re: how show Value when Enter number of days in it

Search on google

As of calendar qlikview by HIC

itsakshaye
New Contributor III

Re: how show Value when Enter number of days in it

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