Can we pass the parameter to the query which in the script of QWV file?.

[shantanu73]

Hi All Experts,

Can we pass the parameter to the query which in the script of QWV file?.

If it is "Yes"/Work out. Then what will be command from command line.

For Eg in script one for the script as follows:-

TabEmp:

Select * from emp where deptno = $(pdeptno)           [Some what Like this query. Where pdeptno will be parameter variable.]

It will great thanks for the solution for the above problem.

Thanks in Advance

Shantanu

[Miguel_Angel_Baeyens]

Hi,

You can either use the command line qv.exe or an include file (i.e.: a plain text file named "variables.qvs") as follows:

SET pdeptno = 23;

Then in the script you call it as:

$(include=variables.qvs);

When you reload, it will read the pdeptno variable in the variables.qvs file. You can change the value in the QVS file (which is a plain text file, that can be open in notepad) without open the QVW file.

The command line option:

"C:\Program Files\QlikView\qv.exe" /vpdeptno=1 "C:\QVWFolder\Document.qvw"

Note the double quotes. I'd rather use the include option.

Hope that helps.

Miguel