Urgent help in straight table please help

[#1]

Hi,

I have data as below, can anyone suggest me how to show in straight table only one date

I need the date to showed as when TO= ALL then MAX(Date). so, I need for ID = 11 the date should be 02/07/2014

ID	FROM	TO	Date
11	XX	XX	06/07/2014
11	pp	XX	02/07/2014
11	ALL	pp	03/07/2014
11	PO	ALL	02/07/2014
11	XX	RR	02/07/2014
11	DO	XX	02/07/2014
11	ALL	DO	23/06/2014
11	CM	ALL	23/06/2014
11	DD	CM	24/04/2014
11	AA	DA	01/04/2014
11	LL	AA	21/10/2013

Thanks.

[#2]

Hi Amelia,

Use aggr function,

=Aggr(Max(Date),ID)

Regards,

Anjali Gupta

[stigchel]

Try with

Only({<TO={'ALL'},Date={'$(=Max(Date))'}>} Date)

[sunny_talwar]

Use FirstSortedValue() function. But the max date seems to be 06/07/2014, are you sure you want 02/07/2014? Also do you want to see this in a chart or a text box object.

[#5]

yes I need only 02/07/2014 please help

[#6]

when I used this it is showing 06/07/2014. but I need only when TO= ALL date is 02/07/2014

please help

[settu_periasamy]

May be this..

=Date(Max({<TO={'ALL'}>}Date))

[#8]

when I used this all dimensions and expression disabled. data not loading. please help

[sunny_talwar]

May be this:

FirstSortedValue({<TO = {'ALL'}>} Date, -Date)

[qlikmsg4u]

i tried like this