Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

stekol61
Contributor

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

Re: How to select previous n days in a report?

Added a trigger to your variable v.Previous

Capture.PNG

9 Replies

Re: How to select previous n days in a report?

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
Contributor

Re: How to select previous n days in a report?

Hi!

I think that the Imput should have the priority

/Stefan

Re: How to select previous n days in a report?

Can you try the attached

stekol61
Contributor

Re: How to select previous n days in a report?

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.

Re: How to select previous n days in a report?

Like the attached?

stekol61
Contributor

Re: How to select previous n days in a report?

Hi!

Looks grate.

How did you fix this?

/Stefan

Re: How to select previous n days in a report?

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

Re: How to select previous n days in a report?

Added a trigger to your variable v.Previous

Capture.PNG

Re: How to select previous n days in a report?

Stefan,

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

Thanks

Anil

Life is so rich, and we need to respect to the life !!!
Community Browser