Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
podge2019
Contributor III
Contributor III

Min Date for two fields

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))

podge2019_0-1614351967844.png

Any assistance would be appreciated.

Labels (2)
1 Solution

Accepted Solutions
rubenmarin

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

View solution in original post

1 Reply
rubenmarin

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

View solution in original post