Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
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