Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

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

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

3 Replies
Highlighted
Creator III
Creator III

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

hi,

you can put all the code?

Highlighted
Partner
Partner

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

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

Highlighted
Not applicable

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

I used the log option to find the solution.

Thanks.