Hi,
can anybody tell me - with the material attached - why my PC is regularly freezing and telling me that the memory is maxed out with just these two formulas (in the diagram in my qvw file)?
The first of these two - the presence_quota, not the absence_quota - is part of nearly all the QlikView apps I have built so far (both quotas are in the resp. diagram which in its turn is part of every app, but that does not pose any problems, it's just this "overview diagram" (supposed to give an overview of all the KPIs in an app, together with the YTD_values which are interesting only on management level). The absence_quota, as you see, is calculated differently - it is not the "turnaround" of the presence_quota - and, well, these two formulas seem to be killing my PC every time.
Can anybody tell me what is there about them that is so resource-intensive - and how I can make it better?
Thanks a lot!
Best regards,
DataNibbler
P.S.: I have tried my best to provide you the original qvw - minus all sensitive data and all sheets that don't touch upon this question - and I have drafted up an XL file with fake data - the original data comes from a database as you see, involving several tables - but that doesn't matter, does it?
In case there is an element missing that you need to fully understand where my problem lies, just tell me.
P.P.S.: Right now, there is a condition causing that diagram to never be calculated at all - that is of course only temporary - I had to include it, otherwise I would have spent much more time because it really takes ages every time I open the page with this diagram.
