Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

value in accordance with a date max

Hi

I have a table with the values above :

PRESCRIPTEUR_NUM          DATE               REALISATOR

12523                                   04/09/2012          karine

12524                                   04/10/2012          lea

12525                                   05/10/2012          karine

12526                                   01/11/2011          fred

I want to find, in a chart, the Realisator for the max of the date

In the example :

max(date) =  05/10/2012

I want to find "karine"

Thanks

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Try this.

     Only({<DATE = {"$(=max(DATE))"}>}REALISATOR)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Anonymous
Not applicable
Author

Hi

Thanks for your responses, but it returns no value

What is the problem ?

Find attached the QV document

Thanks for your help