topic Re: Max with Aggr in QlikView

Max with Aggr

vipingarg23 — Thu, 25 Jan 2018 04:48:59 GMT

Hi Team,

I have below data:

I want output ( maximum of the date) in straight chart as below:

A	B	Date
1	111	01-01-1998

Means, I want max of date for single value of A,B. Can anyone help me out?

prma7799 — Thu, 25 Jan 2018 04:56:29 GMT

try this

Aggr(Max(Date),B)

Aggr(Max(Date),A,B)

vipingarg23 — Thu, 25 Jan 2018 05:03:31 GMT

No..Not working. It is giving me max among all values. Not according to Column A,B

karthikoffi27se — Thu, 25 Jan 2018 05:24:19 GMT

Hi Vipin

try Date(max(Date))

Many Thanks

Karthik

vipingarg23 — Thu, 25 Jan 2018 05:26:41 GMT

It is also not working Karthik.

prma7799 — Thu, 25 Jan 2018 05:41:28 GMT

PFA...

vipingarg23 — Thu, 25 Jan 2018 05:53:33 GMT

Thanks a lot P M

It is working fine. I was doing silly mistake.

Thanks once again for your help.

pradosh_thakur — Thu, 25 Jan 2018 05:54:08 GMT

Check this out