Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
When i am trying to calculate max between 3 dates ,its not populating correctly as its only considering the first row not the second and third.
Example:In the rowwisemax.png file the max between the 3 dates(checkentered,issue,and createdate) is claimtransaction maxdate.
The Logic used to calculate max inside the script level is
BridgeMapping:
Mapping Load DISTINCT
"DIM Claim Transaction Header Key",
"DIM Claim Payment Check Key"
RESIDENT BridgeClaimPaymentCheckTransaction;
CheckIssueDateMapping:
MAPPING LOAD
"DIM Claim Payment Check Key",
Date(Floor("Check Issue Datetime")) As "Check Issue Date"
FROM [lib://$(vQvdFolder)/DIMClaimPaymentCheck.qvd]
(qvd);
CheckEnterDateMapping:
MAPPING LOAD
"DIM Claim Payment Check Key",
Date(Floor("Check Entered Datetime")) As "Check Entered Date"
FROM [lib://$(vQvdFolder)/DIMClaimPaymentCheck.qvd]
(qvd);
Unqualify *;
TransactionDate:
LOAD *,
Date(Monthstart(ClaimTransactionMaxDate),'YYYYMM') as MaxmonthYear;
Load "DIM Claim Transaction Header Key",
Date(Floor(RangeMax(Num(CheckIssueDate), Num(CheckEnterDate), Num("Claim Transaction Create DateTime")))) AS ClaimTransactionMaxDate;
LOAD
*,
ApplyMap('CheckIssueDateMapping', BridgeDimKey) AS CheckIssueDate,
ApplyMap('CheckEnterDateMapping', BridgeDimKey) AS CheckEnterDate;
LOAD
DISTINCT "Claim Transaction Create DateTime",
"DIM Claim Transaction Header Key",
ApplyMap('BridgeMapping', "DIM Claim Transaction Header Key", 'NA') AS BridgeDimKey
//FROM [lib://$(vQvdFolder)/FACTClaimTransactionDetail.qvd]
//(qvd);
RESIDENT [Master FACT Temp];
DROP table [Master FACT Temp];
//unqualify *;
but when we exclusively take this Date(Floor(RangeMax(Num(CheckIssueDate), Num(CheckEnterDate), Num("Claim Transaction Create DateTime")))) inside Qliksense table as an measure its working correctly and showing 4/2/2018 as max date.
Can Anyone please suggest how does Qlik reacts in row wiise calculations.