Store values even after data loads again

[#1]

Hi,

I have created an application with REST connection. the data is scheduled to load daily. I want to store the count of a variable in a table having one row as date field and other as count against each field. Even if data loads this table should not be lost. how to do that?

I have taken the count of the field in a variable let vStart = followers; I want to go on putting this in a table on daily basis. And save this table even if the data loads everyday.

[#2]

changed it. still showing error at autogenerate 1

[#3]

should qvd be a path?

[petter]

At least you have a spelling error in the specification of file type:

(qbd)

should be

(qvd)

[#5]

Thank you,

corrected it. still giving same error.

[#6]

[petter]

The problem is exactly what the error message states:

Instead of referring to a path like:

     C:\Users.....

You must start the path like:

     lib:// ....

Where the lib points to as to the file system is configured in Qlik Sense.

[#8]

tempdatestoretable:

LOAD Count(valuee) AS Followers, Floor(Today()) as StoreDate

RESIDENT ids;

CONCATENATE (tempdatestoretable)

LOAD *

FROM 'lib://libfolder/MyQVDTable.qvd' (qvd)

WHERE Not Exists(StoreDate);

STORE tempdatestoretable INTO 'lib://libfolder/MyQVDTable.qvd' (qvd);

DROP Table tempdatestoretable;

I have created a folder it is still giving invalid path.

[#9]

Should the folder already contain qvd file?

[#10]

Thank you for help. It worked