topic Re: slow performance on aggr and if stmt in App Development

slow performance on aggr and if stmt

SK111 — Wed, 03 Jan 2024 19:09:21 GMT

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!

Re: slow performance on aggr and if stmt

MatheusC — Wed, 03 Jan 2024 20:39:44 GMT

@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/WindowFunctions/Window.htm

Att, Matheus

Re: slow performance on aggr and if stmt

SK111 — Wed, 03 Jan 2024 20:56:48 GMT

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