topic Input Variable as parameter for SQL Select statement? in QlikView

Input Variable as parameter for SQL Select statement?

Wed, 23 Sep 2009 01:54:11 GMT

Hi,

I've added an Input box to my sheet that contains a variable called CompanyID. How can I use that variable in my SQL Select statement, which is in my main script (File | Edit Script)? I've tried something like:

select * from company_lkup where company_id = @CompanyID;

but that didn't work.

Does anyone have an example?

Thanks,

Brian

Input Variable as parameter for SQL Select statement?

Anonymous — Wed, 23 Sep 2009 02:00:55 GMT

select * from company_lkup where company_id = $(CompanyID);

Input Variable as parameter for SQL Select statement?

Wed, 23 Sep 2009 02:07:25 GMT

Thanks Michael 🙂