Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error Dashboard

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

5 Replies
sunny_talwar

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

Error Handling in Qlikview

Not applicable
Author

Thanks!:)

Not applicable
Author

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