QVD load error

[#1]

Hi Experts,

I m loading sales table monthly with the following autogenerate variables

LET vToday = NUM(Today());

LET vBaseMonth = NUM(Month(AddMonths(Today(1)-1,0)));

LET vBaseYear = Year(AddMonths(Today(1)-1,0));

LET vFileMonthName = $(vBaseYear)&'_'& NUM($(vBaseMonth),'00');

then i m storing the monthly file into qvds.

i have sales qvds from Jan 2015 to Apr 2016.

for my report, i m extracting all the sales qvds from Jan 2015 to Apr 2016 and storing into single qvd named 'TotalSales.qvd' in my folder path and i m using this TotalSales (qvd) for my report.

when i get data from this TotalSales qvd for a particular month, i m getting wrong sales value.

but if i get data from the monthly qvd, i m getting correct sales value.

i cant figure the exact reason.

Please help me

[kaushiknsolanki]

Hi,

It seems to be a data issue. What you will have to find is whether you are doing any extra calculation or any logic which is there while creating the TotalSales QVD.

Regards,

Kaushik Solanki

[#3]

No.

i have monthly qvds like

Sales_2015_01

.

.

..

Sales_2015_12

Sales_2016_01

.

.

Sales_2016_04

While loading TotalSales qvd, i do the following

Load *

from

QVD\Sales_*.qvd

(qvd);