topic Re: Need max age in QlikView

Need max age

prma7799 — Mon, 19 Jan 2015 07:04:52 GMT

Hi All,

I want max age of the field...

=if(num(num(date(today())- num(BL_DT_VPC)),'####'),(num(num(date(today())- num(BL_DT_VPC)),'####')))

Thanks

Mon, 19 Jan 2015 07:08:06 GMT

try with age function.

prma7799 — Mon, 19 Jan 2015 07:10:53 GMT

I got two values using (num(num(date(today())- num(BL_DT_VPC)),'####') )

but I want max of above two values...

kamielrajaram — Mon, 19 Jan 2015 07:19:14 GMT

Hi Prashanti,

Try

Aggr(max(your formula),Dealership)

Regards

Kamiel

prma7799 — Mon, 19 Jan 2015 07:24:25 GMT

Dealership is not my dimension I just rename the filed.

when I am using max(num(num(date(today())- num(BL_DT_VPC)),'####') )

in expression then I get max value..

mambi — Mon, 19 Jan 2015 07:36:26 GMT

you can use this function FirstSortedValue()