topic Re: Script error without extra information (try debug it as well) in QlikView

Script error without extra information (try debug it as well)

Wed, 17 Apr 2013 12:52:38 GMT

I have the following code

there must be an error because QV said so but without a clue only script failed.

I tried it also in debug mode.

I have missing data which I want to get rid off using an extra join.

Data is as follows:

Employees key employee_id

Career_learning training code (not all employees have training data)

Mandatory training (a set of 😎 records is left joined with career learning. When there is no career_learning data I miss entries in my table (since the mandatory trainings is vanisched because of the join).

So I want to do it like this:

employee left join with training data and left join this with career data

LJCareer_learning:
LOAD Distinct
EMPLOYEE_ID
RESIDENT Employees;

LEFT JOIN (LJCareer_learning)
LOAD
TRAINING_CODE,
TRAINING_NAME,
TRAINING_REGISTRATION_STATUS,
TRAINING_COMPLETION_YEAR,
TRAINING_COMPLETION_MONTH,
TRAINING_COMPLETION_YYYYMM
RESIDENT Career_Learning;

When I take this code out no errors. But what can be wrong.

I want to make a left join on LJcareer_learning with the mandatory training. The career learning tabel is all training data for employee. There are employees without no training.

John

Re: Script error without extra information (try debug it as well)

Anonymous — Wed, 17 Apr 2013 16:36:58 GMT

hi,

you can put all the code?

Re: Script error without extra information (try debug it as well)

nilesh_gangurde — Wed, 17 Apr 2013 17:02:20 GMT

you can check the script error by generating log file.

go to "Document Properties"=> tick "Generate log"...

then run the script..

log file will generate in the same folder of your qvw file.

check logs......

this is the simplest way to check the script error...

-Nilesh

Re: Script error without extra information (try debug it as well)

Thu, 18 Apr 2013 15:09:02 GMT

I used the log option to find the solution.

Thanks.