Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a table with the values above :
PRESCRIPTEUR_NUM DATE_PREVISION REALISATOR
12523 04/09/2012 karine
12523 06/09/2012 paul
12524 04/10/2012 lea
12525 05/10/2012 karine
12525 05/10/2011 karine
12526 01/11/2011 fred
I want to find, in a chart, the Realisator for the max of the date for each PRESCRIPTEUR_NUM
In the example, I want to find :
PRESCRIPTEUR_NUM DATE_PREVISION REALISATOR
12523 06/09/2012 paul
12524 04/10/2012 lea
12525 05/10/2012 karine
12526 01/11/2011 fred
Attached my document
Thanks a lot
You can try using the firstsortedvalue function. See attached qvw. You do need to decide how you want to handle cases where there are several realisator values for the maximum date of a prescription_num. In such cases the firstsortedvalue function cannot return a result since there's not enough information to determine which value is the correct value to return.
You can try using the firstsortedvalue function. See attached qvw. You do need to decide how you want to handle cases where there are several realisator values for the maximum date of a prescription_num. In such cases the firstsortedvalue function cannot return a result since there's not enough information to determine which value is the correct value to return.