https://community.qlik.com/t5/Qlik-Automate/Error-Management-and-Data-Validity-for-a-dashboard/m-p/2452579#M4012 <P>Hello,</P> <P>How to check the validity of a dashboard, especially if data is extracted from multiple sources.<BR />What are some of the assertions we can put in place to catch errors?</P> Wed, 15 May 2024 08:38:12 GMT Dashboard_Learner 2024-05-15T08:38:12Z https://community.qlik.com/t5/Qlik-Automate/Error-Management-and-Data-Validity-for-a-dashboard/m-p/2452579#M4012 <P>Hello,</P> <P>How to check the validity of a dashboard, especially if data is extracted from multiple sources.<BR />What are some of the assertions we can put in place to catch errors?</P> Wed, 15 May 2024 08:38:12 GMT https://community.qlik.com/t5/Qlik-Automate/Error-Management-and-Data-Validity-for-a-dashboard/m-p/2452579#M4012 Dashboard_Learner 2024-05-15T08:38:12Z https://community.qlik.com/t5/Qlik-Automate/Error-Management-and-Data-Validity-for-a-dashboard/m-p/2474499#M4447 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/299143">@Dashboard_Learner</a>&nbsp;,</P> <P>a better approach is to validate data at the source, before&nbsp;loaded into Qlik:</P> <UL> <LI>Uniqueness: Ensure primary keys are unique.</LI> <LI>Completeness: Check for missing values in critical columns.</LI> <LI>Data Type Validation: Ensure data types are consistent (e.g., dates are in the correct format).</LI> <LI>Range Checks: Verify numeric values fall within expected ranges.</LI> </UL> <P>Hope this helps you</P> Mon, 05 Aug 2024 07:44:06 GMT https://community.qlik.com/t5/Qlik-Automate/Error-Management-and-Data-Validity-for-a-dashboard/m-p/2474499#M4447 F_B 2024-08-05T07:44:06Z