topic Re: Loading Script not ending in QlikView

Loading Script not ending

Wed, 06 Nov 2013 07:53:18 GMT

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.

Re: Loading Script not ending

tresB — Wed, 06 Nov 2013 08:41:26 GMT

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.

Re: Loading Script not ending

kaushiknsolanki — Wed, 06 Nov 2013 09:09:03 GMT

Hi,

Make sure that the variables has got correct values.

Regards,

Kaushik Solanki

Re: Loading Script not ending

Anonymous — Sat, 14 Dec 2013 09:56:56 GMT

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

Re: Loading Script not ending

Tue, 17 Dec 2013 06:07:08 GMT

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.

Re: Loading Script not ending

ramkrishna86 — Tue, 17 Dec 2013 06:11:46 GMT

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

Re: Loading Script not ending

Tue, 17 Dec 2013 06:39:46 GMT

Hello,

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

Can you attach the log file. if possible.

Thanks,

Angad

Re: Loading Script not ending

kamielrajaram — Tue, 17 Dec 2013 07:17:49 GMT

Hi,

Try putting your variables in single quotes.

Regards

Kamiel

Re: Loading Script not ending

nilesh_gangurde — Tue, 17 Dec 2013 07:23:28 GMT

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

Re: Loading Script not ending

Tue, 17 Dec 2013 07:50:44 GMT

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

Re: Loading Script not ending

Anonymous — Sun, 22 Dec 2013 11:46:30 GMT

Hi Arjun

Thanks for this. It does work. Looks like there is a bug in Qlivkview.

I'd like to set and unset this option via a macro something like:

set up = ActiveDocument.GetApplication.GetUserPreferences

up.XXX = true

ActiveDocument.GetApplication.SetUserPreferences up

Anyone know what XXX should be? I've looked in the QV API guide, but I can't seem to find it.

Garry

Re: Loading Script not ending

qlikpahadi07 — Mon, 23 Dec 2013 05:58:44 GMT

Hi Garry and Arjun,

Good you have solved that but No it's not a Bug it's an option available for developers for an ease where you can verify the data rows/tables are loaded correctly. if you make that Selection unchecked then while reloading you can can Monitor all your tables are loaded correctly and if you reload the Application through Server/Publisher still it will not through any error.

but creating a Button will halt at that stage so for your Scenario you have to Check it compulsory.

Hope I am Clear

Re: Loading Script not ending

arngue — Tue, 05 Feb 2019 08:35:35 GMT

Hi,

In my case was a precedent temp table not being dropped and causing extensive synthetic keys.