topic Re: How do I store Now() value into a QVD? in QlikView

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

Wed, 25 Nov 2020 16:16:04 GMT

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!

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

Anil_Babu_Samineni — Mon, 05 Dec 2016 16:45:08 GMT

Can you try like this and let us know

updateTimeStamp:

LOAD Now(1) as updateTime

AutoGenerate Now(1);

STORE updateTimeStamp INTO timeStamp.qvd (qvd);

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

Mon, 05 Dec 2016 16:52:57 GMT

Awesome, thank you!

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

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

Anil_Babu_Samineni — Mon, 05 Dec 2016 17:03:19 GMT

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