topic exit script in QlikView

exit script

francofiorillo — Tue, 07 May 2013 11:46:47 GMT

Hello.

in a sql table I have the company name.

once read the sql table, I would like to stop the script if the value of the company name is different from the one put into a variable.

for example:

September vCompanyName = 'QlikView';

load CompanyName

SQL SELECT CompanyName,

FROM Table;

When exit Script ........... ??

how I should write instead of??.

thank you in antiipo.

hello

swuehl — Tue, 07 May 2013 11:50:48 GMT

I assume your CompanyNameTable table contains only 1 record.

You can access a data model table record from within the script using Peek() function:

Let vLoadedCompanyName = Peek('CompanyName',-1,'CompanyNameTable');

francofiorillo — Tue, 07 May 2013 12:45:24 GMT

hello. Thank you. I've been a lot of help