slow performance on aggr and if stmt

[SK111]

Hello Folks,

Appreciate your time. my expression below is very slow in Qlik table, do you suggest any alternatives

=Aggr(if((Min(cal_date) <= end_date) and (Max(cal_date) >= start_date), start_date), identifier)

thank you!

[MatheusC]

@SK111 

Try putting your expression in the script, something like:

table:
LOAD
*,
identifier
IN [...]
(qvd);

left join (table)
load
identifier,
if(Min(cal_date) <= end_date and Max(cal_date) >= start_date, start_date) as start_date
resident test Group By identifier;

You can also see if the new window function is available in your version and work with it.
https://help.qlik.com/pt-BR/sense/November2023/Subsystems/Hub/Content/Sense_Hub/Scripting/WindowFunc...

Att, Matheus

[SK111]

Appreciate your reply. let me give a try. Thank you!