Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loading Script not ending

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.

12 Replies
tresesco
MVP
MVP

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
MVP & Luminary
MVP & Luminary

Hi,

     Make sure that the variables has got correct values.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
hakuin
Contributor
Contributor

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

Not applicable

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
Creator II
Creator II

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

Not applicable

Hello,

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

Can you attach the log file. if possible.


Thanks,

Angad

kamielrajaram
Creator III
Creator III

Hi,

Try putting your variables in single quotes.

Regards

Kamiel

nilesh_gangurde
Partner
Partner

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

Not applicable

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