Whenever I have a calculated dimension with aggr and if statements, it is always very slow. I don't have a problem with that, but if that chart is on the same sheet as another chart everytime I change the other chart I have to wait for the slow chart to load when it isn't even doing anything. Is there a setting or something to fix this?
Maybe pretty obvious, but when that happens to me I always minimize all objects but the one I'm working on (actually I've got a button to do that). Besides that, do you have any macro that may be changing variable or field values so the chart needs to be rendered again?
Even when I minimize it it still goes slow, just not as slow as it would as if it was open. I don't have any macros or anything going on. It does this really annoying thing where if I click once sometimes it will double click or if I try to drag my mouse and hold the mouse button down it will cancel it, even if the chart is minimized and Qlikview is minimized. It even does this if I'm on a different sheet...
I don't think there's any setting. If the system knew how to calculate it faster, it would do so. If it could be certain it didn't have to recalculate, it would probably skip the recalculation. All I've see are errors in the other directions - QlikView trying too hard to avoid recalculation, and as a result failing to recalculate in some obscure situation when it really needs to.
I know of two main workarounds. First would be to replace your calculated dimension with a real field. Second would be to use an existing field as the dimension, but use more complicated expresssions. Either is likely to be faster than using a calculated dimension, which is almost notoriously slow. A real field would be fastest.
Which to do and how exactly to make such a replacement will depend entirely on the situation.
QlikView should not be recalculating minimized objects, hidden objects, or objects on other sheets.
And yes, there's a lot of things going on simultaneously while QlikView is recalculating. Things could get ugly if you try to interact with it while it's busy.
Hi. This is probably a bit late as your post is a year old, but just to point out you can detatch the chart (use the right-click menu) and it's excluded from recalculations while you're doing other things.
.png "Miguel_Angel_Baeyens"){kind=avatar}
