topic Re: max date by field in QlikView

max date by field

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello!

I have a problem with the aggregation and max in the set analysis.

I need the max date of each field in a set analysis

Team Date

A 1/01/2000

A 1/02/2000

A 1/03/2000

B 2/01/2000

B 3/02/2000

Team aggr(max(Date),Team)

A 1/03/2000

B 3/02/2000

I need something that could give me the date of A and B in set analysis.

I tried with

Date(max(aggr(sum({<Team={'A'}>}Date),Team)))

But it gives me al the Dates from Team A.

Thank you!

Re: max date by field

johnw — Thu, 13 Oct 2016 17:43:50 GMT

Maybe something along these lines?

{<[Date]={"=[Date]=max({1<[Team]={'A'}>} total [Date])"}>}

Re: max date by field

sunny_talwar — Thu, 13 Oct 2016 17:50:15 GMT

How exactly are you using this if you don't mind sharing? May be there is another way to do this?

Re: max date by field

Anonymous — Thu, 13 Oct 2016 17:53:27 GMT

Can you try with this?

{<[Date]={"=aggr(max(Date),Team)"}>}

Re: max date by field

maxgro — Thu, 13 Oct 2016 18:47:09 GMT

concat(TOTAL aggr(Date(max(Date)), Team), ',')

Re: max date by field

el_aprendiz111 — Thu, 13 Oct 2016 22:47:39 GMT

Hi,

from script:

Re: max date by field

Anonymous — Wed, 19 Oct 2016 09:59:25 GMT

I tried all the solutions but it doens´t work.

Thanks for your time!

Re: max date by field

Miguel_Angel_Baeyens — Wed, 19 Oct 2016 10:31:46 GMT

Guillermo,

Not sure if this is exactly what you are looking for:

Count items with max date

Max Date, by 1st Dimension, in Pivot

Miguel

Re: max date by field

Wed, 19 Oct 2016 11:12:33 GMT

Hi,

Can you please try using below.

inp:

load * inline [

Team,Date

A,1/01/2000

A,1/02/2000

A,1/03/2000

B,2/01/2000

B,3/02/2000

];

output:

load Team, max(Date(Date,'DD/MM/YYYY')) as out

Resident inp

Group By Team

Thanks,
Sreeman