Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

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

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))

1 Reply
Not applicable

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

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))

Community Browser