Data Validation in QlikView

[diwakarnahata]

Hi All,

How do we do data validations of QlikView reports wrt database?

Since QlikView doesn't have SQL view, how can we write equivalent SQLs in database and validate the output of QlikView.

Regards,

Diwakar

[mightyqlikers]

Hi,
Query the same in your respective database and see whether the data is correct or not.

this is how you can do..

Regards

Samwise

[agni_gold]

export data from your charts into excel and match with the database .

[buzzy996]

general what ppl will do,

place some selections on data point in qlikview and write queries for same data points in sql and execute on db & compare.

[diwakarnahata]

Hi All,

Agreed, but QlikView uses Associative modelling, so we can't use normal joins between all the tables.

We use IN clause to connect multiple tables which are associated.

Let me know if this approach is correct as it gives correct results.

Regards,

Diwakar

[buzzy996]

Associative modelling it's type of joining,don't worry on this.

you have to keep in mind when u prepare sql scripts how u got those results in qlikview,so accordingly u have to prepare ur queries and execute in ur db and compare.