topic Re: Reload Control in QlikView

Reload Control

tresB — Mon, 29 Apr 2013 07:58:52 GMT

Hello,

i want my script to skip the reload on a condition and to be at the previous load status. that means after it executes the 'Exit Script' command, the application should not go blank, it should come back to it's earlier data position. is there any way to control that?

Thanks.

Re: Reload Control

vikasmahajan — Mon, 29 Apr 2013 10:49:21 GMT

By Writing Macros and run this task externally you can achive the same

by windows schedular you can run macro and base on variable you can.

Re: Reload Control

tresB — Mon, 29 Apr 2013 12:20:33 GMT

Thank you Vikas for your reply. i would usually like to avoid macro and opt for functionality available in qv itself, however, request you to come up with the macro example.

Thanks.

Re: Reload Control

kaushiknsolanki — Mon, 29 Apr 2013 12:56:25 GMT

Hi,

Understand one thing, when ever you reload the application, qlikview will flush all the earlier data.

So there is no direct way to get your data. But you can do one thing. I am just giving you the logic.

All you need to do is create a backup of the Application say ABC_TEST. and the Actual application as ABC.

Now in ABC application you can write some script like shown below.

if (Condition true) then

Reload new data.

else

Reload from the Backup Application (ABC_Backup)

End if

Regards,

Kaushik Solanki

Re: Reload Control

tresB — Mon, 29 Apr 2013 13:22:45 GMT

Thank you Kaushik. You have come up with the alternate solution which i might have to follow ultimately. i was wondering if there is any direct way that qv provides. anyway thanks once again.

Thanks.

Re: Reload Control

kaushiknsolanki — Mon, 29 Apr 2013 18:20:57 GMT

Hi,

I am clear about the data and it is doable. Just give a try and let us know.

Regards,

Kaushik Solanki

Re: Reload Control

tresB — Tue, 30 Apr 2013 05:36:27 GMT

Hi,

yes agree that it is doable, but that would require an extra load. as i mentioned earlier, i am wondering if there is anything (like parameter setting in the document or so) in the product itself.

Thanks.