topic Problem with max() and aggr() function in QlikView

Problem with max() and aggr() function

Anonymous — Tue, 25 Sep 2018 12:34:22 GMT

Hi! I need a help.
Data (example):

What i need in a result (object's quantity of current manager):

Thanks for your ideas

dplr-rn — Tue, 25 Sep 2018 17:08:35 GMT

Can you expand on logic behind the second table

benvatvandata — Tue, 25 Sep 2018 21:07:53 GMT

I'm assuming the Quantity of objects column in your example is based off a date range (using field Appointment_date_manager)?

swuehl — Tue, 25 Sep 2018 21:13:24 GMT

You can flag the current managers in the script, but since you were calling for Aggr in the title, I guess you want a chart based solution, e.g.

Manager	Sum(Aggr(If(Manager = FirstSortedValue(Total<Object> Manager, -Appointment_date_manager),1,0), Object, Manager))
	6
Ivanov	2
Kiselev	1
Kuznetsov	1
Petrov	0
Sidorov	2

swuehl — Tue, 25 Sep 2018 21:19:17 GMT

Or using the script flag:

INPUT:

LOAD Object,

Manager,

Appointment_date_manager

FROM

(html, codepage is 1252, embedded labels, table is @1);

DATA:

LOAD Object,

Manager,

Appointment_date_manager,

If(Previous(Object)<>Object,1,0) as Current

Resident INPUT

Order by Object, Appointment_date_manager desc;

DROP TABLE INPUT;

and in the UI

Anonymous — Wed, 26 Sep 2018 08:46:27 GMT

Thanks a lot! That's really what i need.