Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Marcushenriquesk

How to exclude date based on aggr function

=avg(aggr((RUN_DATE_TIME-RECEIVED_DATE_TIME)*24,ACC_ID))

I am trying to use set analysis in this function to exclude all ACC_IDs that have a run_date_time>= Received_date_time

{<[RUN_DATE_TIME]={'=[RUN_DATE_TIME]>=[RECEIVED_DATE_TIME]'}>}

I have tried using this before the aggr and after the aggr but it does not work as intended.

 

 

Labels (2)
1 Reply
hic
Former Employee
Former Employee

You need double quotes for searches.

Avg({<ACC_ID-={"=[RUN_DATE_TIME]>=[RECEIVED_DATE_TIME]"}>} aggr((RUN_DATE_TIME-RECEIVED_DATE_TIME)*24,ACC_ID))