text object - event when finished calculating?

[rothtd]

What event/function can be used to tell when a text object has finished evaluating it’s expression?

I have a proof of concept application that has ~150 text objects each containing set expressions. My user selects inputs and the text objects recalculate (the entire sheet recalculates in ~30 seconds). My challenge is that my end user doesn't really know if they are looking at the old number or the new number, since the calculation may take a while. I would like to hide all the text objects until they have finished re-calculating, but cannot figure out how to do this. Is there an event, or function to use for this? At what point is an action triggered for a text object – is it when the object is clicked or when it is rendered? Is there a sheet level event that tells me when all expressions on the sheet have finished rendering?

Thanks in advance.

[rothtd · Accepted solution]

I found a work around to this issue.

I created a vCalculateFlag and modified my expressions to be:

=if(vCalculateFlag = ‘TRUE’,

<TheExpression>

)

I also created a vShowReport variable. Using these two variables, I could allow users to modify their input selections, and not compute the final report until all input selections were set. It also fixed the problem where user noticed numbers changing in response to the inputs changing. Again, not the way I typically design, but I wanted a little more of a reporting feel in this case.

[simondachstr]

~150 text objects each containing set expressions ?!?!?!?!?!?

Are you serious?

[rothtd]

Ya, it's far from ideal - but like I said proof of concept. We are in data discovery phase looking for value on this initiative, and uncovering challenges like this. I think we'll have enough value to move to the next phase and restructure the data model so we can stop using set expressions.

It's also a very custom looking financial scorecard with very disparate data arranged in a very particular manner for presentation purposes.

[marcus_sommer]

Maybe it could be an alternatively to use (partly) table-charts instead textboxes. They need not necessarily dimensions. Further there is a user-property for a better view on calculation status within the tab objects - here you could choose detailed instead normal.

- Marcus

[rothtd]

That is an interesting idea, and I think it would be an option.

[simondachstr]

If you want you can then hide all table formats (make them transparent) leaving nothing but the numbers displayed. For a very bespoke formatting you can then use textobjects and lay it under that table. This way you can create calculation friendly and impressive qlikview poc.

[qliksus]

Hi,

Can i know what expression you have written for the variable vCalculateFlag ? Means how the value TRUE stored in vCalculateFlag.

Thanks in Advance