Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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))