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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
kiara
Contributor II
Contributor II

How can I add the condition with aggregated calulated field

I want to add 

max(if([Service.Service Code Raw] = 'H0046' ,[Service Payor.Date of Service]))) > (max(if([Service.Service Code Raw] = 'H0031' or [Service.Service Code Raw] = '90791',[Service Payor.Date of Service])))

into

max(if([Service.Service Code Raw] = 'H0031' or [Service.Service Code Raw] = '90791',[Service Payor.Date of Service]))

Labels (3)
1 Reply
kiara
Contributor II
Contributor II
Author

I tried this way. But I am getting blank space.

=if(
date(aggr(max(if([Service.Service Code Raw] = 'H0031' or [Service.Service Code Raw] = '90791')) , (max(if([Service.Service Code Raw] = 'H0046' ,[Service Payor.Date of Service]))) > (max(if([Service.Service Code Raw] = 'H0031' or [Service.Service Code Raw] = '90791',[Service Payor.Date of Service])))))
,[Service Payor.Date of Service])