topic Re: Data Validation in QlikView

Data Validation

Wed, 27 May 2015 09:05:21 GMT

Hi All

Please tell how to validate data at the back end script part

Thanks Timba

Re: Data Validation

maxgro — Wed, 27 May 2015 09:16:16 GMT

an easy way (at the beginning of the test) is

compare the most significant measures with the same measures in the source database

Re: Data Validation

buzzy996 — Wed, 27 May 2015 09:32:33 GMT

i think,there is no straight approach,

u have to write ur one sql by understanding qlikview scripts, and execute those scripts in ur db server and compare the data.

Re: Data Validation

rajeshvaswani77 — Wed, 27 May 2015 09:33:58 GMT

Hi Timba,

Could you please elaborate more?

Thanks,

Rajesh Vaswani

Re: Data Validation

stevedark — Wed, 27 May 2015 09:36:38 GMT

Hi Timba,

I would put a number of sheets in the document when you have loaded it to just look at what you have in each field.

This app is a useful head start for this:

QlikView App - Generic Data Profiler

I would also add a sheet with MultiBoxes on so you can see the values for every field in a record at the same time (once you have selected an id).

Also, adding as many fields as you sensibly can to a sheet in list boxes can help you eyeball for errors.

Often in apps I will add a validation sheet, and put tables in for some of the errors and inconsistencies that I foresee may occur in the data - IDs without corresponding dimensions, for example.

You may also find this post useful:

http://www.quickintelligence.co.uk/start-your-qlikview-project-the-right-way/

Cheers,

Steve