topic Application continuously reloading data in QlikView

Application continuously reloading data

Anonymous — Tue, 03 Jun 2014 11:54:18 GMT

Good day,

I have an QVW application which constantly reloads data and I do not know why this is happening.

In my script I defined a variable as a measure:

SET M_L_CURR_YEAR_LOAN_PAYOUT =sum(if(Year(LOANTRAN_TDATE) = Year(Now()) and LOANTRAN_LU_TGROUPTYPE_DESC = 'PAYOUT' ,[LOANTRAN_CAPITAL],0));

I make use of these variables in my graphs where I set the expression to:

=$(M_L_CURR_YEAR_LOAN_PAYOUT)

I do not know if this is causing the constant refreshing of data ?!

When I open the specific sheet the data continuously refreshes with the hour glass popping up and the progress bar.

Is this due to the "dynamic" variable ?

The value being displayed is correct on the graph - So the "measure" variable is calculating correctly.

Thank you in advance for your feedback.

Kind regards

Edwin

Re: Application continuously reloading data

Gysbert_Wassenaar — Tue, 03 Jun 2014 12:02:39 GMT

The refresh is only refreshing the expression value and causes recalculation of the charts. It doesn't reload the data. What you see is caused by the now() function, which will update each second. Perhaps the today() function is more appropriate here.

Re: Application continuously reloading data

Anonymous — Tue, 03 Jun 2014 12:15:19 GMT

Thanks yes that was it. Was not aware that expressions recalculate that way. Also very interesting to know. So one can use that to have a "live" dashboard. Might come in usefull at some point in time.

Thank you very much.