Dashboard Reload failure because of "-1 =" error

[Piyush_G]

Hello,

I have a dashboard having 13,14 views and the data model has 4 synthetic keys. Earlier, this dashboard was showing desired results but now I added an indicator filter in the QlikView dashboard showing 'Y' and 'N' values. I am using MSSQL as a backend. In the backend, this indicator field is defined as 'bit' datatype. When I am refreshing the dashboard for top (1000)/top (10000), the dashboard is showing desired results but when I am trying to refresh the full data, it is executing the whole script and at the end giving me a ''-1 ='' error.

For reference, attached is a screenshot of the log file with the error (Last 3 lines).

Please share your thoughts on this.

Thanks in advance.

[NadiaB]

Hi @Piyush_G

The reload is failing likely to the synthetic keys, could you attempt to remove the synthetic keys and let us know the outcome?

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

Thank you in advance.

[Piyush_G · Accepted solution]

Hi @NadiaB ,

Thank you so much for your response.

Yes, I tried removing the Synthetic keys because the data model wasn't created properly. The dashboard is working fine now.

Hope this is helpful!

Thank you!

[NadiaB]

Thank you @Piyush_G  for letting us know that the issue was resolved.