Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

i have created a data model?

i have created a data model  now i want cross check whether my data model is perfect or not? how ? what are steps i have to follow?

1 Solution

Accepted Solutions
Not applicable
Author

Some of the checks you can do.

1.Verify your data model with the source Data

2.You can check count of the records, tallying the records from the source.

3.You can check the values,tallying the source

Regs

Ram

View solution in original post

4 Replies
colin_albert

  • Check for Synthetic Keys and remove them.
  • Check for tables that only have 2 fields and use Mapping Tables and Applymap instead.
  • Check for Isolated Tables or sets of tables.
    These may be correct but users will need to make sure they do not cause a cartesian join by combining data from isolated data sets in the same chart.

Post an image of you data model and I'm sure you will get plenty of help.

giakoum
Partner
Partner

Go to the table viewer and see what you have created.

Best practise rules can be found in the attached document

Not applicable
Author

Some of the checks you can do.

1.Verify your data model with the source Data

2.You can check count of the records, tallying the records from the source.

3.You can check the values,tallying the source

Regs

Ram

View solution in original post

engishfaque
Specialist III
Specialist III

Dear Manoj,

Find attached document, attached document will provide you good understanding.

Kind regards,

Ishfaque Ahmed