Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gauravgg
Partner - Creator
Partner - Creator

store historic Data

Hi

I have the following table

IDPo TypePo DateProcess DateValue
1A01/09/201601/01/20171000
2A05/10/201601/01/20174000
3B06/11/201601/01/20175000

in the above table we have Process Date which has 01/01/2017 ie jan2017 data

in feb2017 the above table will be replaced by feb data.

so in Jan in have to create on qvd of jan2017 and in feb2017 again i have to create qvd of feb2017 and concat to jan2017 qvd

so every month the data will be concat

thanks in advance

1 Reply
vinieme12
Champion III
Champion III

So what do you need help with buddy?

Generally we would create an Archive QVD at the end of everymonth

For example  at the end of Jan Create a QVD for example Archive.QVD

then in Feb

FACT:

load

Archive.QVD  

concatenate

Monthly:

Load

Feb.qvd

IF today() = Monthend(today()) THEN

Store FACT into Archive.QVD

End IF

Then in March you have both Jan+Feb data... hope this makes sense

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.