Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

gauravgg
New Contributor III

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

Tags (2)
1 Reply
vinieme12
Esteemed Contributor II

Re: store historic Data

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

Community Browser