topic Re: I attached my Log file am getting error count = 3 in QlikView

I attached my Log file am getting error count = 3

Mon, 26 Jan 2026 18:19:17 GMT

this is my script :

Binary "\\ukbraa06\Source Documents\QVD\QVD Monitor\QVD_Monitor.qvw";

QVD_legend:

LOAD

rowno() as Leg_QvdId,

QvdShortFileName as Leg_QvdShortFileName,

QvdDesc as Leg_QvdDesc,

QvdReloadFreq as Leg_QvdReloadFreq,

QvdReloadFreq_In_Days as Leg_QvdReloadFreq_In_Days

RESIDENT Qvd_Params

WHERE BSC = 'Y';

LEFT JOIN(QVD_legend)

LOAD

QvdShortFileName as Leg_QvdShortFileName,

QvdCreateDate as Leg_QvdCreateDate

RESIDENT Qvd_Info;

LEFT JOIN(QVD_legend)

LOAD

QvdShortFileName as Leg_QvdShortFileName,

QvdMaxDate as Leg_QvdMaxDate

RESIDENT QVDmaxdate;

LEFT JOIN(QVD_legend)

LOAD

Leg_QvdShortFileName,

Num(Today() - date(Leg_QvdReloadFreq_In_Days + Leg_QvdCreateDate)) as Leg_QvdDelay,

if(Num(Today() - date(Leg_QvdReloadFreq_In_Days + Leg_QvdCreateDate))<=0,0,1) as Leg_QvdIsLate

RESIDENT QVD_legend;

Re: I attached my Log file am getting error count = 3

martin59 — Fri, 31 Jan 2014 11:13:17 GMT

Hi Palla,

Your QvdShortFileName field doesn't exist in the Qvd_Info table of your QVD_Monitor.qvw app.

Review the QVD_Monitor.qvw data model, you should find the right field to use.

Hope that helps you,

Martin Favier

Re: I attached my Log file am getting error count = 3

Fri, 31 Jan 2014 11:23:54 GMT

Hi,

Your Qvd_Info doesn't Contain the Field QvdShortFileName .Check QVD .

Regards,

Divya

Re: I attached my Log file am getting error count = 3

Fri, 31 Jan 2014 11:59:51 GMT

Thanks For all ,problem solved

Re: I attached my Log file am getting error count = 3

martin59 — Fri, 31 Jan 2014 13:12:27 GMT

So,

Could you mark the post as "answered' please ? thx

Martin Favier