Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
francofiorillo
Partner - Creator
Partner - Creator

exit script

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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');

View solution in original post

2 Replies
swuehl
MVP
MVP

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
Partner - Creator
Partner - Creator
Author

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