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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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))