topic Re: Using if condition to store into qvd in QlikView

Using if condition to store into qvd

martyn_birzys — Sat, 13 Dec 2014 11:10:10 GMT

I am loading data into table, but I only want to store data into qvd (overwrite existing qvd) if the the table contains data. If the table contains no data, I want to keep the existing qvd. I am getting an error on if statement:

//load new data

StockLevels:

LOAD "ITEMS";

SQL SELECT

"ITEMS"

FROM "PRODUCTS";

//check

if Count(Peek(ITEMS)) = 0 then

Store StockLevels into ..\QVD\StockLevels.qvd;

end if

Drop Tables StockLevels;

Re: Using if condition to store into qvd

arulsettu — Sat, 13 Dec 2014 11:14:59 GMT

you have to try incremental load concept

check this link

Incremental load in Qlikview

Re: Using if condition to store into qvd

arulsettu — Sat, 13 Dec 2014 11:16:05 GMT

incremental load types

Re: Using if condition to store into qvd

its_anandrjs — Sat, 13 Dec 2014 11:29:26 GMT

Hi,

As i understand you want to store the data into qvd if there is data into the SQL tables otherwise do not store the QVD. Then check for no of rows in the table like

//load new data

StockLevels:

LOAD "ITEMS";

SQL SELECT

"ITEMS"

FROM "PRODUCTS";

LET vNoofRows = NoOfRows('StockLevels');

//check

if $(vNoofRows) > 0 then

Store StockLevels into ..\QVD\StockLevels.qvd;

end if

Drop Tables StockLevels;

Regards

Anand

Re: Using if condition to store into qvd

maxgro — Sat, 13 Dec 2014 22:49:48 GMT

if NoOfRows('StockLevels') > 0 then

trace rows>0;

store ...........;

endif;

Re: Using if condition to store into qvd

Gabriel — Sun, 14 Dec 2014 02:50:44 GMT

Hi,

If I understand you. You want to store data coming from SQL into a table in QVD file if a particular table has data?

What might be worth trying is using QvdTableName.

IF(QvdTableName('D:\Dir\FileName.qvd')) <> 0 THEN

STORE blah blah

ELSE

exit blah blah

ENDIF

Give that a try.

Re: Using if condition to store into qvd

rajeshvaswani77 — Sun, 14 Dec 2014 05:31:57 GMT

Please try

if NoOfRows('StockLevels') > 0 then

Store StockLevels into ..\QVD\StockLevels.qvd;

end if

thanks,

Rajesh Vaswani