Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
aaronnayan
Creator III
Creator III

Store Qvd's on 1st of every month with Date (Snapshot)

Hi Guys,

I need your help on my problem.

I have "Table1" that reloads and is stored into a qvd daily. I would like to copy "Table1" and store into a qvd again but on the first of every month..  (Similar to a snapshot)

?? IF first day of month , Store "Table1" to qvd. ??

I also would like to add to "Table1" the month it stores the data as a field if possible?

I.e

On the 1st April "Table1" is stored to (QVD)  April2019.qvd;  - including the field [StoreDate] =  01/04/19 for every row maybe?

April2019.qvd

May2019.qvd

June2019.qvd

 

10 Replies
Vegar
MVP
MVP


@aaronnayan wrote:

Hi Sorry,

This does not work in QV 11.2 unfortunatley

Aaron


Strange, I don't see which part should be incompatible with QlikView 11.2, where does it fail?  Which part of the script is failing?

(I thougth you where using Qlik Sense as you where posting in New to Qlik  Sense forum.)