topic if isnull(QvdCreateTime('$(vQVDPath)$(vTableName).qvd')) then in QlikView

if isnull(QvdCreateTime('$(vQVDPath)$(vTableName).qvd')) then

nilesh_gangurde — Thu, 23 May 2013 06:15:26 GMT

Hii All,

let vQVDPath = ../Qvds/;

let vTableName = TABLENAME;

I am geting the Error because of "if isnull(QvdCreateTime('$(vQVDPath)$(vTableName).qvd')) then" is not working properly.

when i execute the script Qlikview is not identifying that Qvd is present or not.

if qvd is present then idealy it should go for "Else" but in my some of the Exractor its excecuting the "If" part only which is wrong.

guide how to tackel the same.

-Nilesh

Re: if isnull(QvdCreateTime('$(vQVDPath)$(vTableName).qvd')) then

nilesh_gangurde — Thu, 23 May 2013 06:44:11 GMT

Hii,

This is the Increamental load Script.

the above error is affecting the Increamental load of DATA.

-Nilesh

Re: if isnull(QvdCreateTime('$(vQVDPath)$(vTableName).qvd')) then

kumarnatarajan — Thu, 23 May 2013 06:47:53 GMT

Hi,

Put your variables in string format (single quotes is missing). Condition is right. See below mentioned syntex.

Ex:

LET vQVDPath='..\Data Sources\';

LET vTableName='Employee';

LET vTime=QvdCreateTime('$(vQVDPath)$(vTableName).qvd');

if isnull(QvdCreateTime('$(vQVDPath)$(vTableName).qvd')) then

SET vTesrt=1;

ENDIF;

Re: if isnull(QvdCreateTime('$(vQVDPath)$(vTableName).qvd')) then

nilesh_gangurde — Thu, 23 May 2013 07:20:59 GMT

Yes,

but its woking properly for some Exractor without string format.

-Nilesh