topic Re: Reload old data in script in QlikView

Reload old data in script

ambasadorknz — Tue, 08 Aug 2017 07:36:17 GMT

Hi,

I have problem with reload old data in script.

I want check some condition and if it`s true then load table from database but if it`s false then reload old data...

Example:)

If vA=5 then

Load

...

else

Reload Old Data;

Is it possible? Any Idea?

Re: Reload old data in script

tresB — Tue, 08 Aug 2017 07:38:48 GMT

Yes possible. Have you tried? Is there any issues you are facing?

Re: Reload old data in script

rahulpawarb — Tue, 08 Aug 2017 07:43:07 GMT

Yes it is possible; you can make use of below sample code snippet:

if $(vLoadOldData) <> 0 then
Table1:
LOAD *
FROM Old.qvd(QVD);
ELSE
Table1:
LOAD *
FROM New.qvd(QVD);
ENDIF

Hope this will be helpful.

Regards!

Rahul Pawar

Re: Reload old data in script

Anil_Babu_Samineni — Tue, 08 Aug 2017 07:43:27 GMT

May be this?

LET vNew = Date(Today());

If vA = 5 THEN

Load * From Table where PrimaryKey >= '$(vNew)';

ELSE

Load * From Table Where PrimaryKey <= '$(vNew)';

Re: Reload old data in script

ambasadorknz — Tue, 08 Aug 2017 07:56:47 GMT

I should trace each table to reload old data??

Olik doesn`t have more simply way to solve this problem ( some function like exit stript etc....)??

If vA=5 then

// reload by new data

Table1:

Load from dbo.orders;

Table2:

Load from dbo.Clients;

else

// reload by old data

Table1

Load from //filepath/report_name.qvd(QVD);

Table2:

Load from //filepath/report_name.qvd(QVD);

ENDIF

Re: Reload old data in script

Miguel_Angel_Baeyens — Tue, 08 Aug 2017 08:23:20 GMT

Yes it does, EXIT SCRIPT is the syntax. When this statement is read, the script finishes. See here for further reference and options to use WHEN or UNLESS along with EXIT SCRIPT:

Exit script ‒ QlikView

Actually your code is quite similar to an actual QlikView script, and can be further refined to cover more cases.

Re: Reload old data in script

ambasadorknz — Tue, 08 Aug 2017 09:09:09 GMT

When i use Exit Script Table1 and Table2 are empty... but i need old data in Table1 and Table2.

Re: Reload old data in script

Miguel_Angel_Baeyens — Tue, 08 Aug 2017 13:05:36 GMT

Perhaps your load statements are not correct or the tables or files empty?

Re: Reload old data in script

ambasadorknz — Tue, 08 Aug 2017 13:24:33 GMT

load statement is correct

table isnt empty

Example below

Re: Reload old data in script

Miguel_Angel_Baeyens — Tue, 08 Aug 2017 15:30:42 GMT

In the ELSE you only have EXIT SCRIPT; if you still want the old data you will need to load it there, otherwise if minute is less than 30 then the script does nothing (exits)

Re: Reload old data in script

ambasadorknz — Wed, 09 Aug 2017 08:46:05 GMT

So... i should load .qvd file before exit script??

What exactly do exit script.

Look at include file, reload it with param vtime to skip to ELSE statement check results and next comment line with exit script and reload again.

Both of this scripts do the same... so do i need EXIT SCRIPT??

I`m not expert that pleas explain me difference more simple:)