topic Re: Urgent help in straight table please help in QlikView

Urgent help in straight table please help

Wed, 02 Sep 2015 09:58:25 GMT

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.

Re: Urgent help in straight table please help

Wed, 02 Sep 2015 10:02:18 GMT

Hi Amelia,

Use aggr function,

=Aggr(Max(Date),ID)

Regards,

Anjali Gupta

Re: Urgent help in straight table please help

stigchel — Wed, 02 Sep 2015 10:02:53 GMT

Try with

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

Re: Urgent help in straight table please help

sunny_talwar — Wed, 02 Sep 2015 10:03:09 GMT

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.

Re: Urgent help in straight table please help

Wed, 02 Sep 2015 10:07:32 GMT

yes I need only 02/07/2014 please help

Re: Urgent help in straight table please help

Wed, 02 Sep 2015 10:08:07 GMT

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

settu_periasamy — Wed, 02 Sep 2015 10:09:19 GMT

May be this..

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

Re: Urgent help in straight table please help

Wed, 02 Sep 2015 10:09:34 GMT

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

Re: Urgent help in straight table please help

sunny_talwar — Wed, 02 Sep 2015 10:11:15 GMT

May be this:

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

Re: Urgent help in straight table please help

qlikmsg4u — Wed, 02 Sep 2015 10:14:14 GMT

i tried like this

Re: Urgent help in straight table please help

Wed, 02 Sep 2015 10:15:15 GMT

not working

Re: Urgent help in straight table please help

Wed, 02 Sep 2015 10:15:19 GMT

Hi Amelia,

Do you want to take the date based on maximum occurrence of it and

also want to show only one record or all records of that date?

Re: Urgent help in straight table please help

stigchel — Wed, 02 Sep 2015 10:18:31 GMT

Use

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

Re: Urgent help in straight table please help

sunny_talwar — Wed, 02 Sep 2015 10:19:18 GMT

Where exactly are you trying to show this?

Re: Urgent help in straight table please help

Wed, 02 Sep 2015 10:23:15 GMT

yes and only one record.

Re: Urgent help in straight table please help

sunny_talwar — Wed, 02 Sep 2015 10:31:01 GMT

See this:

Re: Urgent help in straight table please help

Digvijay_Singh — Wed, 02 Sep 2015 10:34:35 GMT

Try this -

Date(Max(Aggr(Max({<TO={'ALL'}>}Date#(Date,'DD/MM/YYYY')),TO)))

Re: Urgent help in straight table please help

Digvijay_Singh — Wed, 02 Sep 2015 10:38:11 GMT

Re: Urgent help in straight table please help

Wed, 02 Sep 2015 10:41:53 GMT

Hi Amelia,

You can use this:

=Mode( {$< To={'ALL'} >} Date) as expression

and ID as dimension