topic Re: Max date for all rows in QlikView

Max date for all rows

Tue, 20 Oct 2015 01:54:01 GMT

Hi ,

I have a straight table with

ID Orderno endDate

1 1 1/10/2015

1 2 3/10/2015

I want to display this in straight table like below with max date

ID Orderno endDate

1 1 3/10/2015

1 2 3/10/2015

Can you please help me with this logic.

Thanks
karthik

Re: Max date for all rows

sinanozdemir — Tue, 20 Oct 2015 02:19:13 GMT

Hi,

In the expression, you can use Max(Total [End Date]):

Hope this helps.

Re: Max date for all rows

Tue, 20 Oct 2015 02:42:07 GMT

Hi Sinan,

Thanks for that , it work if we have only 1 id, but if we have multiple ids it does not work

Say

ID Orderno enddate

1 1 1/10/2015

1 2 3/10/2015

2 1 10/10/2015

3 1 11/10/2015

i want the straight table like below

ID Orderno enddate

1 1 3/10/2015

1 2 3/10/2015

2 1 10/10/2015

3 1 11/10/2015

Thanks
Karthik

Re: Max date for all rows

settu_periasamy — Tue, 20 Oct 2015 02:45:21 GMT

Try

=max(TOTAL <ID>enddate)

Re: Max date for all rows

sinanozdemir — Tue, 20 Oct 2015 02:46:11 GMT

I am not at my computer, but try this Aggr(Max(Enddate), ID)

Thanks

Re: Max date for all rows

Tue, 20 Oct 2015 03:01:18 GMT

Hi Settu,

Thanks a lot this logic.. it works , but can we do like this if i have selected the max date and need to display its order no in the same field.

For example:

ID Orderno enddate

1 2 1/10/2015

1 1 3/10/2015

2 1 10/10/2015

3 4 11/10/2015

3 2 23/10/2015

i want the data like below

ID Orderno enddate final_orderno

1 2 1/10/2015 1

1 1 3/10/2015 1

2 1 10/10/2015 1

3 4 11/10/2015 2

3 2 23/10/2015 2

Thanks in advance

Regards

Karthik

Re: Max date for all rows

settu_periasamy — Tue, 20 Oct 2015 03:12:28 GMT

Hi Karthik,

sorry, I didn't get you. What based the "final_orderno" should get arrived?

Re: Max date for all rows

Tue, 20 Oct 2015 03:28:44 GMT

HI Settu,

based on max(date), we need to get its order no and should populate for each row where the id is same

Thanks
Karthik

Re: Max date for all rows

settu_periasamy — Tue, 20 Oct 2015 03:34:50 GMT

Hi Karthik,

Try this

=if(isnull(if(enddate=Max(TOTAL <ID>enddate),Orderno)),Above(Orderno),if(enddate=Max(TOTAL <ID>enddate),Orderno))

Note: I'm trying to simplify this