Error Dashboard

[#1]

Dear colleagues,

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

1.      What files from the bunch of files were not loaded
2.      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!

BR

Vitalii

[sunny_talwar]

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

Error Handling in Qlikview

[sunny_talwar]

Another useful link:

Error Handling in Qlikview | Business Intelligence

[#4]

Thanks!:)

[#5]

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!

BR

Vitalii

[sunny_talwar]

May be load your files using for loop instead of *

Loops in the Script