Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends , I am new to qlik. please help.
I want to add 1 more condition in my if statement with aggregation function and that is a calculated field.
I need to add add 1 more condition in the following expression :
min(if([Service.Service Code Raw] = 'H0031' or [Service.Service Code Raw] = '90791',[Service Payor.Date of Service]))
Condition to add:
(max(if([Service.Service Code Raw] = 'H0046' ,[Service Payor.Date of Service]))) <= (min(if([Service.Service Code Raw] = 'H0031' or [Service.Service Code Raw] = '90791',[Service Payor.Date of Service])))
Actually these are measures in the table. In these expressions I am trying to get the maximum or minimum date of service a based on the service code .
Like in this expression min(if([Service.Service Code Raw] = 'H0031' or [Service.Service Code Raw] = '90791',[Service Payor.Date of Service]))
I am getting the min of date of service for codes h0031 and 90791. But for some codes I want that "date of service should be greater than date of service of Hoo31 and 90791.
I hope it gives some clarity.
All these are calculated fields that's why I am getting difficulty with aggregated functions.
Try something like this, if you can share sample data/app, more help can be provided
rangemax/rangemin //based on what is needed, use aggr if required based on results
(
min({<[Service.Service Code Raw]={'H0031','90791'}>}[Service Payor.Date of Service]),
Max({<[Service.Service Code Raw]={'H0046'}>}[Service Payor.Date of Service])
)