Loading Script not ending

[#1]

Hi,

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.....

Help me out.

[tresesco]

Strange! Is your load button's load action preceded by some other actions? Could you post a sample? Because I can't replicate the issue.

[kaushiknsolanki]

Hi,

     Make sure that the variables has got correct values.

Regards,

Kaushik Solanki

[Anonymous]

Hi Arjun

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.

Garry Gelade

[#5]

Hi Garry,

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.

[ramkrishna86]

Please check the value of you variable cdate>= $(vStartDate) and cdate<=$(vEndDate). It seems it is going into infinite loop.

[#7]

Hello,

I hope you are using EXIT Script; statement in your script.

Can you attach the log file. if possible.

Thanks,

Angad

[kamielrajaram]

Hi,

Try putting your variables in single quotes.

Regards

Kamiel

[nilesh_gangurde]

Hi,

The date format of these two variables and the date format of your Date Field should be same.

You can check the the Date format is proper or not ...

-Nilesh

[#10]

Did you check whether the data type of the date columns are getting populated? Pls check.