when i'm doing join this table in final aap with join of transection date "RECEIPT_DATE" then i's cration null date in my qvs . what could be the resone if there is no null date and value in source table .
LOAD
DATE([Tran Date],'DD/MM/YYYY') AS DATE,
//floor(date([Tran Date])) as RECEIPT_DATE,
date([Tran Date]) as RECEIPT_DATE,
Payment,
[Project name]
FROM
(qvd);
now result is in attached
NOTE- its working fine when i'm making qvw for only this table , problem in when i'm adding in final application with all table
I feel like it's a data isssue, please check the data field whether all the data are in date format are a mixture of date and text. And also cross check which join condition your using and its impact .
If you still face the issue please upload your app
