Flag first upload of each month

[jp_afc]

To my app i upload twice a month. The first upload isnt always on the 1st of each month it can be on the 2nd/3rd and so on.

Ive created qvd's to store this.

How can I flag the first upload of each month?

[JandreKillianRIC]

Hi @jp_afc 

I would just build a test for testing the qvd. 

The code is QvdCreateTime('File.qvd').

So something like 

LET zListqvdexists=isnull(QvdCreateTime('File.qvd'));  // if qvd exists then 0 else -1

Let zFlag = zListqvdexists;

You can then add this as a field (Using a resident load) before you store the file or alternatively add this flag to the QVD filename... 

Here is the link to the documentation 

https://help.qlik.com/en-US/sense/November2024/Subsystems/Hub/Content/Sense_Hub/Scripting/FileFuncti...

Regards Jandre