Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Not applicable

I attached my Log file am getting error count = 3

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;

4 Replies
martin59
Valued Contributor II

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

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

Not applicable

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

Hi,

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

Regards,

Divya

Not applicable

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

Thanks For all ,problem solved

martin59
Valued Contributor II

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

So,

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

Martin Favier

Community Browser