Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Urgent help in straight table please help


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

                                                                                                            

IDFROMTODate
11XXXX06/07/2014
11ppXX02/07/2014
11ALLpp03/07/2014
11POALL02/07/2014
11XXRR02/07/2014
11DOXX02/07/2014
11ALLDO23/06/2014
11CMALL23/06/2014
11DDCM24/04/2014
11AADA01/04/2014
11LLAA21/10/2013

Thanks.

18 Replies
Not applicable

Re: Urgent help in straight table please help

Hi Amelia,

Use aggr function,

=Aggr(Max(Date),ID)

Regards,

Anjali Gupta

Partner
Partner

Re: Urgent help in straight table please help

Try with

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

Re: Urgent help in straight table please help

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.

Not applicable

Re: Urgent help in straight table please help

yes I need only 02/07/2014 please help

Not applicable

Re: Urgent help in straight table please help

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

please help

Re: Urgent help in straight table please help

May be this..

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

Not applicable

Re: Urgent help in straight table please help

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

Re: Urgent help in straight table please help

May be this:

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

qlikmsg4u
Valued Contributor

Re: Urgent help in straight table please help

i tried like this

11.PNG22.PNG