I have a load scripts that first takes a start date and end date from sheet1 of the qlikview dashboard and loads the data from QVD files accordingly.
SEARCH:
LOAD *
FROM
$(vFilename)(qvd) Where cdate>= $(vStartDate) and cdate<=$(vEndDate);
where vStartDate and vEndDate are variables set using a calender object in sheet1 of the dashboard.
There is a Button named 'Go' that has Action = Reload. When i click the button, the reloading happens but never stops. But instead, i press Ctrl+R, then reloading happens properly.....
I have the same sort of problem. My Load Button calls a Reload action, but the system hangs without finishing the load. On the other hand, selecting Reload from the File... menu works perfectly. The script to be executed on reload is:
if vLoad_ISL_data = 1 Then
Call Load_ISL_Data;
end if
if vLoad_Sentiment = 1 Then
Call Load_Sentiment;
end if
if vLoad_TAS_categories = 1 Then
Call Load_TAS_categories;
end if
LET vLupdate = Today();
EXIT SCRIPT;
I suspect the problem has nothing to do with qvd files /selecting dates etc. The only thing in common I can see is that we are both using variables.
Just make sure that you have checked the 'Close when Finished' in the bottom right corner of the loading window and try reloading again. That was the only change i did and it worked. Don't know how!! But just give it a try.
