No, that's not what I meant. For example the KPI has an expression like this: =Rand(100)
A random number is displayed. The random function will be evaluated/called every time the sheet will change/re-render. For example when you select any field on any chart on the sheet.
My question is, how can I trigger a new evaluation of the expression manually? How can I trigger the KPI value to get a new random number and to display the new number without select something or reload the whole application?
Did you get any solution for this item? I'm also in need of a solution like that, but I have not found it yet and could not do anything.
In my case, I have a table with values from a DIRECT QUERY that updates the data in memory every 10 seconds for example (SET DIRECTCACHESECONDS = 10). The problem is that the data in the memory is updated, and in the view not. To update the view, I have to execute the "doReload" function (impossible because it is slow).
More and more I realize, that Qlik is not suitable for "live" or near real time updates. :/