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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Identify value of something at a minimum and maximum of the selected dates

Hi,

Am am trying to calculate a metric to describe how something has changed over time but I am unsure how to begin coding this. Core to this is that I want to be able to identify what a value (rating) is for a minumum and maximum of the selected dates. The dates may not always be the full range of the data and so I don't think I can do if(min(date) ....).

rating change.png

Thanks for help in adavance,

Isabel

1 Solution

Accepted Solutions
Not applicable
Author

I have now solved this. The top line gives me the performance rating at the minumum and maximum of the seleected dates whilst the bottom line simply calculates the number of years that have passed:

=((sum({<[Year]={"$(=vMax_date)"}>} [Performance Rating])) - (sum({<[Year]={"$(=vMin_date)"}>} [Performance Rating])))
/
((
vMax_date)-(vMin_date))

View solution in original post

1 Reply
Not applicable
Author

I have now solved this. The top line gives me the performance rating at the minumum and maximum of the seleected dates whilst the bottom line simply calculates the number of years that have passed:

=((sum({<[Year]={"$(=vMax_date)"}>} [Performance Rating])) - (sum({<[Year]={"$(=vMin_date)"}>} [Performance Rating])))
/
((
vMax_date)-(vMin_date))