How initialize Variables through Table Box selection?

Thu, 13 May 2010 11:43:50 GMT

My general idea is following:
User have on the sheet 2 Table Box
1st - with parameters (ObjectID = "tblParam")
2nd - result set (ObjectID = "tblResult")

When user select (click) any row in "tblParam"
initialize the variables (vParam1, vParam2, vParam3) and reload SQL-query related with "tblResult".

Edit script has following code:

sqlTblParam:
SQL SELECT 1 as Param1, 120 as Param2, 0.51 as Param3
UNION
SELECT 1 as Param1, 120 as Param2, 0.52 as Param3
UNION
SELECT 2 as Param1, 120 as Param2, 0.5 as Param3
UNION
SELECT 3 as Param1, 120 as Param2, 0.5 as Param3;

sqlTblResult:
SQL SELECT * FROM tblData WHERE Param1 = $(vParam1) and Param2 = $(vParam2) and Param3 = $(vParam3);

I see this implementation so:
Step 1 - after user choice I need initialisation the variables (vParam1, vParam2, vParam3)
Step 2 - Reload sqlTblResult

Please give me hint how can I do this idea?

How initialize Variables through Table Box selection?

Thu, 13 May 2010 13:43:29 GMT

Is it possible (up)?

How initialize Variables through Table Box selection?

Fri, 14 May 2010 08:28:15 GMT

the question is urgent.

see above

topic How initialize Variables through Table Box selection? in QlikView

How initialize Variables through Table Box selection?

How initialize Variables through Table Box selection?

How initialize Variables through Table Box selection?