Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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