Automated Script

[sujeetsingh]

I need a automated script for reload in Qlikview.

i have a Menu table :

Here i have to check the presence of a brand LEVIS

LEVISCheck:

select  distinct Brand_Name from MenuTable

where Brand_Name='LEVIS';

Now If the Brand name exsist then i have to load the LEVIS Dictionary table.

------------------------CHECK SCRIPT------------

Let RowCount=NoOfRows('LEVISCheck');

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

------------------------------------------------------

LevisDetails:

select ID,ProductNo,order ,Stock,Price

from LEVIS_Data;

end if;

Now in case there is no LEVIS Brand then the error comes that Table Not found .

How to avoid this error.

[sujeetsingh · Accepted solution]

Jagan ,

I do not want to use this function in .

Well I am now going for macro.

thank You guys for your valuable reply

[nilesh_gangurde]

Sujeet

For your information qlikview server wont excecute the macro, hence if you are planing to schedule the exctractor then it will not work.

-Nilesh