topic Re: Reload previous data in QlikView

Reload previous data

jpengiu — Wed, 13 Jul 2011 13:44:08 GMT

Hi all,

is possible to do a thing like this in a script?

if ......

reload previous data

else

select.....

end if

Thank all.

Re: Reload previous data

martin59 — Wed, 13 Jul 2011 13:50:38 GMT

Yes it's possible :

IF condition THEN
     treatment;
ELSE
     treatment;
END IF

Hope that helps you

Re: Reload previous data

jpengiu — Wed, 13 Jul 2011 13:55:01 GMT

I try to explain better..

I want to do a thing like this

if condition then

reload previous data (like when the script goes in error)

else

select (my script)

end if;

It's possible?

Thank u.

Re: Reload previous data

martin59 — Wed, 13 Jul 2011 13:58:04 GMT

I'm not sure to understand well.

If your script is wrong, you want to retrieve your old version ?

if that's you want, it's automatic when you check the option : "save automatically before reload"

Re: Reload previous data

jpengiu — Wed, 13 Jul 2011 14:07:02 GMT

Sorry...i try to explain more better..

i have a table-check that say me if db sql datas are right or wrong.

If data are wrong i don't want to load them (i load them in publisher) and i want to reload previous data (i wanto to mantain the qvw file non reloaded)

So i do this

If flag=0 (flag is the result of my table-check, flag=0 means that data,not scirpt, are wrong)

i want to reload previous data (data that are in qvw) LIKE when a script goes in error (when the script goes in error qlik ask me if i want to relod old data).

I hope u understand...sorry for my english!

Thank u so much.

Re: Reload previous data

rwunderlich — Wed, 13 Jul 2011 22:13:53 GMT

Another way to say this is that for a server reload, if flag=0, you don't want to save the reloaded copy. You can do this by making the script fail with a syntax error.

IF flag=0 THEN

fail me; // Any invalid statement

ENDIF

The task will be in a failed status and the source and distributed copies will not get updated. The old content will be there for users.

-Rob

http://robwunderlich.com

Re: Reload previous data

jpengiu — Thu, 14 Jul 2011 06:47:02 GMT

I'm a stupid.....

Thank you so much!