topic How to change the if condition in QlikView

How to change the if condition

Thu, 19 Jun 2014 04:07:50 GMT

Hi We are Loading QVDs from Database based on the below code

if not isnull(QVDCreateTime('$(vQVDPath)IDS_$(tableName).qvd')) then

LoadTime:

Load Max(LastModifiedDate) as LastModifiedDate // Or max(CreatedDate)

From $(vQVDPath)IDS_$(tableName).qvd (qvd);

Let vLastExecTime = timestamp(peek('LastModifiedDate',0,'LoadTime'),'YYYY-MM-DD hh:mm:ss');

//Let LastModifiedTimestamp = '$(vLastExecTime)';

Drop Table LoadTime;

ELSE

Call FullTableLoad(tableName);

EXIT SUB;

end if;

According to this if QVD is not AVailable on that particular path its doing a full load,

now what we need is if QVD is Availbale and contains 0 records then again it has do a full load

we need to write and if condition here. please help me

Re: How to change the if condition

sujeetsingh — Thu, 19 Jun 2014 04:42:00 GMT

Use row count function in your iff

Re: How to change the if condition

sujeetsingh — Thu, 19 Jun 2014 04:44:44 GMT

some thing like this

Let RowCount= NoOfRows('ActionCheck');

If '$(RowCount)' <> '0' THEN

Here Action check is a table.

You can call the qvd and do full reload and then check for the NoOf Rows

Re: How to change the if condition

SunilChauhan — Thu, 19 Jun 2014 04:48:35 GMT

Try this

if not isnull(QVDCreateTime('$(vQVDPath)IDS_$(tableName).qvd')) or (exists('$(vQVDPath)IDS_$(tableName).qvd') and QvdNoOfRecords('$(vQVDPath)IDS_$(tableName).qvd')=0) ) then

LoadTime:

Load Max(LastModifiedDate) as LastModifiedDate // Or max(CreatedDate)

From $(vQVDPath)IDS_$(tableName).qvd (qvd);

Let vLastExecTime = timestamp(peek('LastModifiedDate',0,'LoadTime'),'YYYY-MM-DD hh:mm:ss');

//Let LastModifiedTimestamp = '$(vLastExecTime)';

Drop Table LoadTime;

ELSE

Call FullTableLoad(tableName);

EXIT SUB;

end if;

hope this helps

Re: How to change the if condition

Thu, 19 Jun 2014 05:33:17 GMT

Hi Sunil,

Thanks for the Reply ,

Yes It Will work .Thanks a Lot

Regards

Abi