Qlik Community

Qlik Sense Integration, Extensions, & APIs

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

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').

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Store Calculated Value in QVD

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);

3 Replies

Re: Store Calculated Value in QVD

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

erikzions
Contributor

Re: Store Calculated Value in QVD

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

Re: Store Calculated Value in QVD

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);

Community Browser