How to divide QVD table into Two parts?

[siva_boggarapu]

Hello There,

I have one QVD table in Qlikview Report. I want to make this QVD into two parts. One QVD should load last 3 months data and 2 nd QVD should load last 3 days data. How come it is Possible?

Best,

Siva.

[Jason_Michaelides · Accepted solution]

Maybe try:

Table1:

Load

   *

From QVDFile(qvd)

Where DateField >= AddMonths(Today(),-3);

Table2:

NoConcatenate

Load

   *

From QVDFile(qvd)

Where DateField >= Today()-3;

Hope this helps,

Jason