Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Not applicable

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

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!

Tags (2)
1 Solution

Accepted Solutions
Highlighted

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

Can you try like this and let us know

updateTimeStamp:

LOAD Now(1) as updateTime

AutoGenerate Now(1);

STORE updateTimeStamp INTO timeStamp.qvd (qvd);

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

3 Replies
Highlighted

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

Can you try like this and let us know

updateTimeStamp:

LOAD Now(1) as updateTime

AutoGenerate Now(1);

STORE updateTimeStamp INTO timeStamp.qvd (qvd);

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

Highlighted
Not applicable

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

Awesome, thank you!

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

Highlighted

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)