Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
narayanaqlik
Creator
Creator

How to calculate last 10days, 15days, like that dynamically in qliksense?

Hi All,

Here i need calculate Number of actions as due  based on the number entered in input box.

here i have on due date field, and i am entering one value through input box,  based on input box enter value like last 10 days , 20, days, or 30 days it may be any dynamic value entered in the input box in bar chart need to display how many actions are in pending for taking actions on each Function name (X-Axis).

I am entering one value through input box that should be passed into Expression then it will display values

means based on the the due date should be selected like >= entered number days (if entry value is 10 from last 10 days  )

Due date should be taken up to Today date only

 

i think you can understand my Explanation.

 

Please give me good Expression.. Thanks to everyone in advance...!

 

 

 

1 Solution

Accepted Solutions
narayanaqlik
Creator
Creator
Author

Hi Kush, Thanks for your response. Here , user is enter some number (Like last 10 days or 40 days some random values) then it should last 10 days risks/issues.

But i got the answer.

Count({=$(=Today(),-(VarEnterDays))<= $(=Today()-1)"}>}Risksid)

View solution in original post

2 Replies
Kushal_Chawda

How many input box you are using and what are the expected input from input box?

narayanaqlik
Creator
Creator
Author

Hi Kush, Thanks for your response. Here , user is enter some number (Like last 10 days or 40 days some random values) then it should last 10 days risks/issues.

But i got the answer.

Count({=$(=Today(),-(VarEnterDays))<= $(=Today()-1)"}>}Risksid)