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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-05-28 11:14 AM

Returning values within a set range

Good afternoon, I need to do some averages on some data but I only want to use the most recent date and a date thats as close to as a year ago as possible. i.e.

28.05.2012

24.02.2012

10.10.2011

08.07.2012

29.05.2012

26.05.2012

Above is a range of dates using the most recent date and a date up to a year ago(as close as possible) ignoring all the data inbetween.

How do I go about this?

Kind regards.

Paul.

2,301 Views
0 Likes
10 Replies
Not applicable
‎2012-05-31 08:09 AM
Author

In response to flipside

Thanks for your help. This has been a good learning experience, Luckily I got to the result I needed by correctly applying First sorted Value.

136 Views
0 Likes