Error Management and Data Validity for a dashboard

[Dashboard_Learner]

Hello,

How to check the validity of a dashboard, especially if data is extracted from multiple sources.
What are some of the assertions we can put in place to catch errors?

[F_B]

Hi @Dashboard_Learner ,

a better approach is to validate data at the source, before loaded into Qlik:

• Uniqueness: Ensure primary keys are unique.
• Completeness: Check for missing values in critical columns.
• Data Type Validation: Ensure data types are consistent (e.g., dates are in the correct format).
• Range Checks: Verify numeric values fall within expected ranges.

Hope this helps you