maximum between dates row wise calculation

rapradha — Wed, 25 Nov 2020 16:16:04 GMT

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.

topic maximum between dates row wise calculation in QlikView

maximum between dates row wise calculation