Read Data Quality Rules in Qlikview/Qlik Sense

[michelabarsottini]

Hi Experts,

we would like to read all the Data Quality (both Validation and Cleansing) Rules in Qlikview or Qlik Sense, to be able to browse the rules in a single dashboard.

We made a copy of the ProjectRepo.sqlite and found the location of the rules in the field "json" of the objects table, but the repository seems to have a delayed update time comparing to the changes made in Compose.

For example: ProjectRepo.sqlite is updated at 31/05/2023, but yesterday I added a new cleansing rule and it does not show up in the field values.

Anyone has experienced this? Do you have any ideas on how to read/export the data quality rules?

Thanks 

Michela

[Nanda_Ravindra]

@michelabarsottini is this topic related to QLik Compose or QLik View/QLik Sense? If this is related to QLik compose, you may want to check in the runtime repository sqlite file for the new cleansing rule that you added.

Hope this helps!

Thanks,

Nanda