Min Date for two fields

podge2019 — Fri, 26 Feb 2021 15:09:18 GMT

Have a straight table doing basic enough count.

For something like the first 3 columns I have:

Claims Registered Count = Count(CR_Agent_Name)

MIN - Claim Registered Date = =FirstSortedValue(DISTINCT CR_Claim_Registered_Date,CR_Claim_Registered_Date)

MAX - Claim Registered Date =FirstSortedValue(Distinct CR_Claim_Registered_Date,-CR_Claim_Registered_Date)

For the last columns “Claims Denied” the count is a little different as I have to sum two fields together:

Claims Denied Count = Count(CD_Agent_Name)+ Count(CDCFAL_Agent_Name)

The issue for me then is that both of these fields have dates coming in separately so I need to get the min and max across two fields essentially.

Closest I’ve come is using Rangemin( CD_Trans_Date, CDCFAL_Trans_Date)

This gives me the minimum date, however, I cant seem to use distinct with the RangeMin and gives me a – in the date field.

I’ve tried a variety of expressions from across the Qlik Forums but with no joy.

=FirstSortedValue (Concat(DISTINCT CD_Trans_Date, CD_Trans_Date),

FirstSortedValue (Concat(DISTINCT CDCFAL_Trans_Date, CDCFAL_Trans_Date)))

=FirstSortedValue (DISTINCT ( Rangemin( CD_Trans_Date, CDCFAL_Trans_Date)))

=FirstSortedValue (Concat (DISTINCT CD_Trans_Date, CDCFAL_Trans_Date))

Any assistance would be appreciated.

Re: Min Date for two fields

rubenmarin — Sat, 27 Feb 2021 10:56:21 GMT

Hi, Have you tried this?: Rangemin(Min(CD_Trans_Date), Min(CDCFAL_Trans_Date))