inside the straight table object I get real time data only the first time I make a selection, the next times I get data from the cache (for Direct Discovery query results) even if time limit ( 300 seconds = 5 minutes) is reached.
While using a sample Sum(Amount) as straight table expression it works as expected (that is when time limit is reached Qlikview queries the source data for selections and recreates the cache for the designed time limit), but unfortunately I need to do an IF condition to perform the right calculation.
It seems you have to do a document reload to perform the query on database and to get data updated inside the straight table.
Is this a bug ? or is there another way to achieve what I need ?