Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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