topic Re: Passing the variables to QlikView Externally in QlikView

Passing the variables to QlikView Externally

Wed, 08 May 2013 07:24:38 GMT

Hi folks,

I've a queery on passing the variable to qlikview externally.

To be clear we've a loader that reloads the qvds corresponding to two different qvws. eg: if the variable vReload=1 it refreshes the qvds corresponding to first qvw, else if vReload=2 it refreshes the qvds corresponding to second qvw.

I have created a batch to reload this Loader.

My question is whether we can pass this variable externally from batch so that we can reload what we want. I would also like to know if we can pass the variable from QlikView Publisher reload.

Kindly advise.

Thanks,

Surendra

Re: Passing the variables to QlikView Externally

anandathome — Wed, 08 May 2013 08:21:51 GMT

Hi Surendra,

Did you try passing the variable from command line?

qv.exe /r/vMyvar=1 QV1.qvw

/v is for passing variable and there is no space between /v and variable name.

Let me know if it helps.

-Anand.

Re: Passing the variables to QlikView Externally

anandathome — Wed, 08 May 2013 11:50:57 GMT

Hi Surendra,

Did this work for you?

-Anand.

Re: Passing the variables to QlikView Externally

Thu, 09 May 2013 07:52:55 GMT

Hi Anand,

I'm really sorry that I couldn't reply to you yesterday.

My question is how does qlikview take the variable to reload it?

I'm using the below batch script to reload it

"C:\Program Files\QlikView\QV.exe" /r /vRun="2" "C:\Users\surendra-m\Desktop\SOW.qvw"

The reload fails since qvw could n't pick the variable we're supplying.

Below is the QlikView script

let vRun=;

if $(vRun)=1 then
[AppTickets]:

LOAD * INLINE [
    Application, No of Tickets
    Actual Spend, 14
    BCP, 4
    GIS, 17
    GPTI, 15
    Other QlikView Applications, 22
    General Activities, 9
];

end if

if $(vRun)=2 then

Tickets:
LOAD Month,
     Year,
     left(Month,3)&'-'&Right(Year,2) as MonthYear,
     Service,
     Incident,
     [Non GPTI Applications]
FROM

(ooxml, embedded labels, table is Sheet1);

end if