Solved: Re: passing parameters in url - Qlik Community

adiarnon · ‎2014-09-01

HI,

im using th ie plugin.

i need to pass variable as parameters in the url

i know how to pass one variable ->http//......qvw?v_year=2013

but i dont know what the syntax for more than one variable

can you help?

adi

arthur_dom · ‎2014-09-02

create a new variable like vParameters, on vParameters pass all the parameters with a delimiter like:

qvp://servername/document.qvw?vParameters=1|jan|2014|Test

and on the variables use the subfield function to make input values, like:

vProductCode= subfield(vParameters,'|', 1) ;

vMonth= subfield(vParameters,'|', 2) ;

vYear= subfield(vParameters,'|', 3) ;

vPlace= subfield(vParameters,'|', 4) ;

View solution in original post

Gysbert_Wassenaar · ‎2014-09-01

If it's possible at all to pass variables then probably something like http//......qvw?v_year=2013&v_month=12.

talk is cheap, supply exceeds demand

adiarnon · ‎2014-09-01

tnx,

but i tried it and its not working

other option?

phaneendra_kunc · ‎2014-09-01

probably you might have it..but checking..

Do you those variables in your targeting QVW already?

URL wont create variables i belive.. except it updates..

adiarnon · ‎2014-09-01

yes, the variables exist in the target QVW

phaneendra_kunc · ‎2014-09-01

this is first time i am seeing such a syntax of passing Variables through URL... Not sure even this is possible or not..

May be other friends in this community might know.

As far as i know i have used...below and there is a good documentation around this aswell.

QlikView Mashups - Simple Document Integration

URL Composer = compute an Access-Point link and pass selection values, open sheets etc.

Alternatively you can do this...if you have same columns in both QVW's..you can use below systax of selecting your year and month and you can create variables like "getfieldselections" or somthing...

http://localhost/QvAJAXZfc/opendoc.htm?document=Sales%20Compass.qvw&select=LB01,2008,2009&select=LB02,12"

here LB01 is year list box and LB02 is Month list box that is in target QVW. these doens't need to be visible in the UI, but they should be there in any sheet hidden.

MarcoWedel · ‎2014-09-01

Maybe

qvp://servername/document.qvw?var1=1&var2=2

arthur_dom · ‎2014-09-01

You can create a another variable to receive all parameters using a delimiter (like '|' ) , and then use subfield function to change all the others { subfield(newVariable, '|',1) }.

adiarnon · ‎2014-09-02

I TRIED IT

TNX

adiarnon · ‎2014-09-02

tnx,

but as far as i know this syntax dosent work with IE plug in

if someone know how can i use this functionality with IE plugin it will be very helpfull!