Selection causing grey X and refresh button

[#1]

Hi, I have just started QV and encountered this weird behaviour:

whenever I select something in an object, the object becomes greyed with an X and a refresh button like so:

Has anyone ever encountered this and knows how to solve it?

Does anyone know what can cause this behaviour?
I looked on the forum and there is one similar question with no answers.

Thanks

-Nick

Thanks

[#2]

Hi Nick,

Have your Qlikview datamodel (Qlikmart) is build and working fine?

Try reloading your application with fresh data and this problem should get resolved.

Hope this help,

Anosh Nathaniel

[#3]

This behavior happens after a sucessfull reload of the data.

The database doesn't seem to the problem, I will continue to investigate this issue.

-Nick

[#4 · Accepted solution]

I fixed it!
The problem happens when your database contains an invalid foreing key.

In addition I found another bug in QlikView, if a mediator table is empty and the two mediated tables contain data, when these tables are loaded, the "script execution progress" does not return any errors but when you click done, you get the "failed to load data" error message.