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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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])