Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Data Validation

Hi All

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

Thanks Timba

4 Replies
Highlighted
MVP
MVP

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

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

Highlighted
Master II
Master II

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.

Highlighted
Specialist III
Specialist III

Hi Timba,

Could you please elaborate more?

Thanks,

Rajesh Vaswani

Highlighted
MVP & Luminary
MVP & Luminary

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