topic Re: QVD load error in QlikView

QVD load error

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: QVD load error

kaushiknsolanki — Mon, 04 Apr 2016 11:26:37 GMT

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

Re: QVD load error

Mon, 04 Apr 2016 11:36:30 GMT

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);