topic using outer variable in QlikView

using outer variable

Sat, 21 Nov 2009 19:26:18 GMT

I am going to get a variable from user before loading data ,and limit data with this value in where condition of load or select .

like this :

IDProduct : get from users

select * from tab1 where ID=$IDProduct;

how can i do it ?

prieper — Sun, 22 Nov 2009 01:44:53 GMT

Variables need to be included in brackets: $(IDProduct), if it is a string, it should be included in apostrophs:

IDProduct : get from users
select * from tab1 where ID='$(IDProduct)';

HTH
Peter

Sun, 22 Nov 2009 13:16:24 GMT

How can i use stored procedure output in other scripts

like this :

sql_sp: SQL declare @ID_Hogh int Execute BSICRS.[dbo].[S_IDPprices] @ID_Hogh=@ID_Hogh output

Select @ID_Hogh as result;

let ID_SP = load result resident sql_sp;

select * from table1 where ID=$(ID_SP );

thanks