Value from a max date

[leocattqv]

Hi All,

I am stumpped on a seemingly easy question.

I have a table that shows

Business Unit	Yr/Mon Orig	MonthEndDate	CPM
Dept 1	2015/01	1/31/2015	2,047
Dept 2	2015/01	1/31/2015	2,364
Dept 3	2015/01	1/31/2015	2,936
Dept 1	2015/02	2/28/2015	1,726
Dept 2	2015/02	2/28/2015	2,239
Dept 3	2015/02	2/28/2015	2,365
Dept 1	2015/03	3/31/2015	1,963
Dept 2	2015/03	3/31/2015	2,101
Dept 3	2015/03	3/31/2015	2,008
Dept 1	2015/04	4/30/2015	1,868
Dept 2	2015/04	4/30/2015	2,083
Dept 3	2015/04	4/30/2015	2,288
Dept 1	2015/05	5/31/2015	1,729
Dept 2	2015/05	5/31/2015	1,831
Dept 3	2015/05	5/31/2015	2,027
Dept 1	2015/06	6/30/2015	1,702
Dept 2	2015/06	6/30/2015	1,610
Dept 3	2015/06	6/30/2015	1,748

what I a trying to do is display the latest CPM for that Dept - in this case its the bottom 3 numbers..  Again, I know this is simple but can someone point me the right direction?

thanks

-L

[swuehl]

Take care that your dates are interpreted by QV as such and show a numeric representation.

Then create a straight table chart with dimension Business Unit and as expression

=FirstSortedValue(CPM, -MonthEndDate)

[maxgro]

in a chart with Business Unit as dimension,

the expression should be

FirstSortedValue (CPM, -MonthEndDate)

[leocattqv]

thank you Massimo, that worked.

thanks,

-L

[maxgro]

Please close the thread giving helpful and/or correct answers.

Thanks

[qlikviewwizard]

Hi Please close the thread giving helpful and/or correct answers.