Solved: When I open QVW I see strange things... - Qlik Community

hansdevr · ‎2016-11-16

When I open a certain QVW I'm working on, I see this:

Anyone any idea why I don't see gauges and pics I'm expecting?

BTW, a single refresh or reload brings them back...

marcus_sommer · ‎2016-11-16

I experienced this with QV 8 and QV 10 quite often and now with QV 11 very rarely. I think the reason for this behaviour is that you hit any limits regarded to available Object-RAM, timeouts by the calculations and maybe an issue with the caching-engine from qlik.

At first I would take a look on the used dimensions/expressions and trying to optimize them in combination with possible changes on the datamodel - to avoid calculated dimensions, aggr-functions, nested if-loops and maybe some more.

- Marcus

View solution in original post

marcus_sommer · ‎2016-11-16

I experienced this with QV 8 and QV 10 quite often and now with QV 11 very rarely. I think the reason for this behaviour is that you hit any limits regarded to available Object-RAM, timeouts by the calculations and maybe an issue with the caching-engine from qlik.

At first I would take a look on the used dimensions/expressions and trying to optimize them in combination with possible changes on the datamodel - to avoid calculated dimensions, aggr-functions, nested if-loops and maybe some more.

- Marcus

hansdevr · ‎2016-11-16

Hi Marcus and thank you very much for your swift reply!!

I think you must be right there. There is a LOT going on in this qvw; it's a real hog. I will do the optimalisations you recommended! There are some quite complex set analysis functions going on here, and some nested ifs; the latter will be the first to go..