Solved: Problem with max() and aggr() function - Qlik Community

Anonymous · ‎2018-09-25

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

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

Thanks for your ideas

swuehl · ‎2018-09-25

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

dplr-rn · ‎2018-09-25

Can you expand on logic behind the second table

benvatvandata · ‎2018-09-25

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

swuehl · ‎2018-09-25

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 · ‎2018-09-25

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 · ‎2018-09-26

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