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: 
stekol61
Creator
Creator

How to select previous n days in a report?

Hi!

In my enclosed report i want to be able to enter a value for n previous days.

E.g. if I enter "21" I want to see the previous 21 days in the graphs

I should also be possible to manually select any date range in the Calender Oblect.

How can this be done?

/Stefan

1 Solution

Accepted Solutions
sunny_talwar

Added a trigger to your variable v.Previous

Capture.PNG

View solution in original post

9 Replies
sunny_talwar

Which one should take priority, your selection or your input? I mean what if you select 10 days and your input box says show last 21 days?

stekol61
Creator
Creator
Author

Hi!

I think that the Imput should have the priority

/Stefan

sunny_talwar

Can you try the attached

stekol61
Creator
Creator
Author

Hi!

I can see that the left modified graph works for previous days.

However it will be a problem if you also want to manually select a data range.

The document uses a Trigger "OnOpen" that show the previous 20 days when the report is opened.

Is it possible to have a similar trigger that react on change on if the v.Previous parameter is changed?

/Stefan.

sunny_talwar

Like the attached?

stekol61
Creator
Creator
Author

Hi!

Looks grate.

How did you fix this?

/Stefan

sunny_talwar

Hahaha don't remember, let me check and revert back to you

sunny_talwar

Added a trigger to your variable v.Previous

Capture.PNG

Anil_Babu_Samineni

Stefan,

If you got the solutions, Please close this thread and mark the Correct answer..!

Thanks

Anil

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful