Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sony
Contributor II
Contributor II

Improper use of island fields may lead to performance problems.

Hi, I have run document analyzer on my dashboard. I'm getting the error - 'The expression uses a Field from an island table. Improper use of island fields may lead to performance problems'. I have loaded data from 2 sheets from a data file in the following way:
LOAD 

(fields)

From lib://DatFolder/DataFile.xlsx

(ooxml, embedded labels, table is Sheet1);

LOAD 

(fields)

From lib://DatFolder/DataFile.xlsx

(ooxml, embedded labels, table is Sheet2);

Can anyone please help in resolving the issue.

 

Thank you!

1 Solution

Accepted Solutions
Or
MVP
MVP

This message means exactly what it says - one of your tables is not connected to any other table in your data model. When you use that in an expression, there is a possibility of it causing a major performance issue (as well as incorrect values) due to the lack of a join. If this is done intentionally, you can ignore the message. If it is not, you've probably missed the join between your tables.

View solution in original post

1 Reply
Or
MVP
MVP

This message means exactly what it says - one of your tables is not connected to any other table in your data model. When you use that in an expression, there is a possibility of it causing a major performance issue (as well as incorrect values) due to the lack of a join. If this is done intentionally, you can ignore the message. If it is not, you've probably missed the join between your tables.