How do I store Now() value into a QVD?

[#1]

Hi Folks,

Simple question here.  I'm looking to store the Now() function output into a field and then write that table to a QVD so I can reference it in another QVW.  This process is mostly used to capture data load since this QVW runs to build QVD's and another QVW runs to display those QVDs.

My script is the following:

LET time = NOW(1);

updateTimeStamp:

  LOAD $(time) as updateTime;

STORE updateTimeStamp

INTO timeStamp.qvd (qvd);

This results in an error about a missing FROM statement.  Not sure why.

Any help is greatly appreciated, i'm sure it's a quick fix!

Thanks!

[Anil_Babu_Samineni · Accepted solution]

Can you try like this and let us know

updateTimeStamp:

LOAD Now(1) as updateTime

AutoGenerate Now(1);

STORE updateTimeStamp INTO timeStamp.qvd (qvd);

[#3]

Awesome, thank you!

I was close but wasn't sure how to use AutoGenerate properly.

[Anil_Babu_Samineni]

Glad to help you! Here, I used for AutoGenerate Would be for increment Till same functionality running on Inline Qlikview Memory.

And, I've used that for till that variable i need to get stuff for the same

You may try this too

SET time = NOW(1);

updateTimeStamp:

  LOAD $(time) as updateTime

  AutoGenerate $(time);

STORE updateTimeStamp INTO timeStamp.qvd (qvd);

For Ref to understand the intend, I would read these links

Autogenerate Your Data

How to generate year sequence in a Qlikview table? - Stack Overflow