Qlik Community

Ask a Question

Qlik Sense Integration, Extensions, & APIs

Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Store Calculated Value in QVD

Hi,

I have a QVD with a dataValue (in the example the 'date as lastDateQvd').

I need to update this value with the date of today:

let dateNow = today(1);

[dateFromQVD]:

LOAD

  date as lastDateQvd

FROM [$(Loadworkpath)data.qvd](qvd);

After  the load there is some operation and at the end I hate to update the qvd with the $(dateNow) instead of the dataValue (in the example the 'date as lastDateQvd').

1 Solution

Accepted Solutions
Not applicable

Thanks for the support but I solved in this way: because of the qvd is composed by only a variable I replace the unique old data with the new one:


[tabUpdate]:

load replace(data,'$(dataLastUpdating)', '$(dateNow)') as data

FROM [$(Loadworkpath)data.qvd](qvd);

store [tabUpdate] into [$(Loadworkpath)data.qvd](qvd);

View solution in original post

3 Replies

Where is the dataValue that you are referring to in your post above?

Creator
Creator

I would just use the variable in your script.

let vDateNow = today(1);

[dateFromQVD]:

LOAD

  '$(vDateNow)' as lastDateQvd

FROM [$(Loadworkpath)data.qvd](qvd);

Not applicable

Thanks for the support but I solved in this way: because of the qvd is composed by only a variable I replace the unique old data with the new one:


[tabUpdate]:

load replace(data,'$(dataLastUpdating)', '$(dateNow)') as data

FROM [$(Loadworkpath)data.qvd](qvd);

store [tabUpdate] into [$(Loadworkpath)data.qvd](qvd);

View solution in original post