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
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
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-30 04:18 AM

getting last value within YTD(+60 day) range

Hi Good morning, I am using the expression:- FirstSortedValue(Meter_Reading,-Meter_Reading_Date) to get the most recent value extract from a QVD I use.

I am now looking to get the furthest single record that falls between 425 and 365 days from most recent value date.

Help much appreciated if you can.

Paul.

Labels (1)
Labels
537 Views
0 Likes
1 Reply
Not applicable
‎2012-05-30 09:00 AM
Author

Anyone?

314 Views
0 Likes