topic Re: How to get a maximum value with a key field. in QlikView

How to get a maximum value with a key field.

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

Hi guys,

How can I get the maximum from a duplicated key in load script.

Example:

In this case I would like to see the table below:

S/N	Date
1	20/10/2015
2	30/10/2015

Is there a way of doing that?

Thanks in advance.

Gysbert_Wassenaar — Wed, 30 Mar 2016 16:39:32 GMT

Use S/N as dimension and Max(Date) as expression

sunny_talwar — Wed, 30 Mar 2016 16:40:19 GMT

I would just use Date(Max(Date)) as expression to get a date field instead of number

Chanty4u — Wed, 30 Mar 2016 16:41:31 GMT

try,

load *,

......

max(Date)

from table where [sn]=1 and [sn]=2;

Kushal_Chawda — Wed, 30 Mar 2016 16:44:19 GMT

Data:

LOAD [S/N],

date(max(Date)) as Date

FROM Table

Group By [S/N]

Kushal_Chawda — Wed, 30 Mar 2016 16:45:30 GMT

Yes, that you can format it from Number Tab of Table

sunny_talwar — Wed, 30 Mar 2016 16:47:58 GMT

Why take some extra steps. My fingers hurt when I do that