topic Re: Error Dashboard in QlikView

Error Dashboard

Mon, 21 Nov 2016 19:07:12 GMT

Dear colleagues,

I would like to create an “Error Dashboard” in my application that would show the following:

What files from the bunch of files were not loaded
Type of the error has happened

The problem is I load many files from different folders with the help of “*” and let’s say 95% of those flat files are correct.

I want to get each end every Error Message for each of the “wrong” 5% of flat files.

Example:

Table_1:

Load

Field1,

Field2,

Field3

From

[..\Folder1\*.xlsx];

Table_2:

Load

Field4,

Field5,

Field6

From

[..\Folder2\*.xlsx];

Is that possible to create such a dashboard? How can I get each and every error message for each and every “wrong” file?

Thank you very much!

Vitalii

Re: Error Dashboard

sunny_talwar — Mon, 21 Nov 2016 19:14:50 GMT

Look into this document which might help you create if statements to look into all the errors

Error Handling in Qlikview

Re: Error Dashboard

sunny_talwar — Mon, 21 Nov 2016 19:15:20 GMT

Another useful link:

Error Handling in Qlikview | Business Intelligence

Re: Error Dashboard

Mon, 21 Nov 2016 19:17:25 GMT

Thanks!:)

Re: Error Dashboard

Mon, 21 Nov 2016 19:51:28 GMT

Sunny,

I used that info and created some variables:

let vError=ScriptError;

let vErrorDetails=ScriptErrorDetails;

let vErrorCount=ScriptErrorCount;

let vErrorList=ScriptErrorList;

Later I showed them in the front end in a text object like that: =$(vError...)

Problem:

- Only vErrorCount showed me value "2", though I damaged only one file in one place, so there should be only one error

- vErrorList showed me "Error: Garbage after expression "Not"", though the full text of error message would be "Field 'Line#' not found" (the one that I damaged/renamed)

- other variables show just "-"

- I still cannot see the name of the file where the error took place

Are there any solutions to that?

Thanks a lot!

Vitalii

Re: Error Dashboard

sunny_talwar — Mon, 21 Nov 2016 20:05:08 GMT

May be load your files using for loop instead of *

Loops in the Script