topic Re: Data Validation in QlikView in QlikView

Data Validation in QlikView

diwakarnahata — Wed, 18 Mar 2015 09:31:36 GMT

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

Re: Data Validation in QlikView

mightyqlikers — Wed, 18 Mar 2015 09:41:53 GMT

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

Re: Data Validation in QlikView

agni_gold — Wed, 18 Mar 2015 10:12:11 GMT

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

Re: Data Validation in QlikView

buzzy996 — Wed, 18 Mar 2015 11:03:56 GMT

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.

Re: Data Validation in QlikView

diwakarnahata — Wed, 18 Mar 2015 11:36:05 GMT

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

Re: Data Validation in QlikView

buzzy996 — Wed, 18 Mar 2015 11:47:20 GMT

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.