Discussion Board for collaboration on QlikView Publisher.
this is my script :
Binary "\\ukbraa06\Source Documents\QVD\QVD Monitor\QVD_Monitor.qvw";
rowno() as Leg_QvdId,
QvdShortFileName as Leg_QvdShortFileName,
QvdDesc as Leg_QvdDesc,
QvdReloadFreq as Leg_QvdReloadFreq,
QvdReloadFreq_In_Days as Leg_QvdReloadFreq_In_Days
WHERE BSC = 'Y';
QvdCreateDate as Leg_QvdCreateDate
QvdMaxDate as Leg_QvdMaxDate
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
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,
Your Qvd_Info doesn't Contain the Field QvdShortFileName .Check QVD .
Thanks For all ,problem solved
Could you mark the post as "answered' please ? thx