topic Re: Automated Script in QlikView

Automated Script

sujeetsingh — Mon, 27 Jan 2014 06:48:03 GMT

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.

Re: Automated Script

Mon, 27 Jan 2014 07:18:54 GMT

Can you try using Peek function and storing the value from LEVISCheck table to a variable. And then try condiitional IF based on this newly created variable?

Does this meet your expectations?

Re: Automated Script

nilesh_gangurde — Mon, 27 Jan 2014 07:24:43 GMT

Hi,

dont put 0 in the single quotes.

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

this should be like below.

If '$(RowCount)'<> 0 THEN

Try and let us know.

-Nilesh

Re: Automated Script

Mon, 27 Jan 2014 07:34:06 GMT

Can you try below:

If RowCount <>'0' THEN or

If RowCount <>0 THEN

Thanks,

Angad

Re: Automated Script

sujeetsingh — Mon, 27 Jan 2014 08:04:33 GMT

Re: Automated Script

Mon, 27 Jan 2014 08:16:29 GMT

Hi,

You can also set the ErrorMode= 0 : you will have an error, but that will not interrupt your process.

You may use also:

Tables:

SQLTables

In order to see the tables that have been read. But in your case, not sure, you will not have also an error.

Fabrice

Re: Automated Script

Peter_Cammaert — Mon, 27 Jan 2014 08:18:08 GMT

Simplest method: use Lookup() function. Returns NULL if nothing found and doesn't require you to create a new table that may or may not exist.

For example:

LET vLevisExists = Lookup('Brand_Name', 'Brand_Name', 'LEVIS', 'MenuTable');

IF len(trim('$(vLevisExists)')) > 0 THEN

// Load Levis details table

END IF

or something like this. Note that this works even if MenuTable doesn't exist...

Peter

Re: Automated Script

sujeetsingh — Mon, 27 Jan 2014 08:19:34 GMT

i can not set error mode to 0 because it will hide other valid reasons too .

Re: Automated Script

sujeetsingh — Mon, 27 Jan 2014 08:20:29 GMT

Guys,

do we have any function to find the reloaded tables in Qlikview .

Re: Automated Script

jagan — Mon, 27 Jan 2014 08:37:20 GMT

Hi Sujeet,

You can try using TableName() and TableNumber() functions for this. Please find below example. Table Number starts from 0.

Month:

LOAD * INLINE [

Month

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

];

LET vTableNumber = TableNumber('Month');

LET vTableName = TableName(TableNumber('Month'));

So, now vTableNumber = 0 and vTableName = Month after reloading.

Regards,

Jagan.

Re: Automated Script

sujeetsingh — Mon, 27 Jan 2014 09:59:37 GMT

Jagan ,

I do not want to use this function in .

Well I am now going for macro.

thank You guys for your valuable reply

Re: Automated Script

nilesh_gangurde — Mon, 27 Jan 2014 11:28:23 GMT

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