Data Validation

[#1]

Hi All

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

Thanks Timba

[maxgro]

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

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

[buzzy996]

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.

[rajeshvaswani77]

Hi Timba,

Could you please elaborate more?

Thanks,

Rajesh Vaswani

[stevedark]

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