Need some help with a formula

datanibbler — Thu, 26 Sep 2013 13:47:06 GMT

Hi,

I have one formula - for a presence_quota, which has to be in every one of my QlikView apps - that is currently causing me a headache: In some apps, it's causing a breakdown and I can't think my way through to make it simpler and less resource-heavy.

I developed that formula with some help from the Community in the first place. I hope you can help me with it once more.

It would be too complex to write here (rather, it would make the post really long), so I will just attach it all:

- A qvs file with a master_calendar that is loaded in all my QlikView apps and that has all the required base fields.

- A txt file with the code I have for the avg. of the past week, for the avg. of the past month and for the YTD average.

It all seems to work, but it seems to be really resource_heavy and regularly makes my laptop freeze, especially the last one (for the YTD_average).

Maybe some of you have experience in "resource-tuning" their objects?

Thanks a lot!

Best regards,

DataNibbler

topic Need some help with a formula in QlikView

Need some help with a formula