Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

laurent_ankri
New Contributor

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

Tags (2)
2 Replies

Re: value in accordance with a date max

Hi,

     Try this.

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

Regards,

Kaushik Solanki

laurent_ankri
New Contributor

Re: value in accordance with a date max

Hi

Thanks for your responses, but it returns no value

What is the problem ?

Find attached the QV document

Thanks for your help

Community Browser