I have a memory problem with using a dynamic field in Qikview.
I just a date(Created by a Calendar component) wich is variable. So i can pick a date out of the calendar, my field changes in the date i have selected and then in my pivot table every expression is going to be calculated with this new selected date.
So in several expression i use an If(......>Variable,....,......) to make some calculations.
Thing thing i want to know is that i maybe can precalculated every calculation in the expressions in the script so that the calculations doesn't need to be done when i make a selection of a different date.
Does anybody have an idea how to create a loop function that loop every single dat for the past 10 years and make the calculation of the functions in my expression in this loop so that they are precalculated en faster to load in my application
I'm not following. An example file or at least some actual expressions might help. But I really don't think it's a good idea to precalculate every expression in a chart for every possible value that can be selected. There is almost certainly a better solution for your problem.
