Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
evgeniystuchalk
Partner - Creator II
Partner - Creator II

Store variables to QVD

Hello! I want to save some logs about load script. All information accumulated in variables. After script execution i want save this variables in qvd.

For first load, i whrite this:

UpdateLog:

load

now() as UpdateStart,

now()-$(vStart) as amoUpdateTime,

$(vCompleteReload) as ReloadMode;

store notes into [Lib://QVD (win-lng2sl4osbd_qlik.acc)/amoCRM/amoUpdateLog.qvd] (qvd);

but its don work. what to do?

1 Solution

Accepted Solutions
danansell42
Creator III
Creator III

Maybe because there is no 'FROM' statement

Try adding AutoGenerate 1 at end of statement.

UpdateLog:

load

now() as UpdateStart,

now()-$(vStart) as amoUpdateTime,

$(vCompleteReload) as ReloadMode

AutoGenerate 1;

store UpdateLog into [Lib://QVD (win-lng2sl4osbd_qlik.acc)/amoCRM/amoUpdateLog.qvd] (qvd);

View solution in original post

3 Replies
danansell42
Creator III
Creator III

At what point does it fail?

I notice you have said "store notes" whereas the table name appears to be UpdateLog

Maybe this is the problem?

evgeniystuchalk
Partner - Creator II
Partner - Creator II
Author

I have noticed that im trying save wrong table. But "store notes" is not a reason. Debugger stops here:

0444e2bef5.jpg

danansell42
Creator III
Creator III

Maybe because there is no 'FROM' statement

Try adding AutoGenerate 1 at end of statement.

UpdateLog:

load

now() as UpdateStart,

now()-$(vStart) as amoUpdateTime,

$(vCompleteReload) as ReloadMode

AutoGenerate 1;

store UpdateLog into [Lib://QVD (win-lng2sl4osbd_qlik.acc)/amoCRM/amoUpdateLog.qvd] (qvd);