topic Re: passing parameters in url in QlikView

passing parameters in url

adiarnon — Mon, 01 Sep 2014 13:24:32 GMT

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

Re: passing parameters in url

Gysbert_Wassenaar — Mon, 01 Sep 2014 14:18:28 GMT

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

Re: passing parameters in url

adiarnon — Mon, 01 Sep 2014 14:20:58 GMT

tnx,

but i tried it and its not working

other option?

Re: passing parameters in url

phaneendra_kunc — Mon, 01 Sep 2014 14:31:05 GMT

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..

Re: passing parameters in url

adiarnon — Mon, 01 Sep 2014 14:45:48 GMT

yes, the variables exist in the target QVW

Re: passing parameters in url

phaneendra_kunc — Mon, 01 Sep 2014 17:32:03 GMT

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.

Re: passing parameters in url

MarcoWedel — Mon, 01 Sep 2014 18:27:26 GMT

Maybe

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

Re: passing parameters in url

arthur_dom — Mon, 01 Sep 2014 18:46:39 GMT

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) }.

Re: passing parameters in url

adiarnon — Tue, 02 Sep 2014 05:01:14 GMT

I TRIED IT

TNX

Re: passing parameters in url

adiarnon — Tue, 02 Sep 2014 05:05:31 GMT

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!

Re: passing parameters in url

adiarnon — Tue, 02 Sep 2014 05:06:11 GMT

sorry. bat i didnt understand your solution

Re: passing parameters in url

arthur_dom — Tue, 02 Sep 2014 12:14:34 GMT

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) ;

Re: passing parameters in url

adiarnon — Wed, 03 Sep 2014 08:08:16 GMT

tnx!!

Re: passing parameters in url

sela — Thu, 31 Mar 2016 16:22:31 GMT

Hi,

I try to pass variable on URL like your example (http//......qvw?v_year=2013),

But it didn't worked.

What is the exect syntax for passing one variable?

Thanks, Sela

Re: passing parameters in url

arthur_dom — Tue, 05 Apr 2016 12:06:42 GMT

First, verify if the variable is already created, second if it haven't triggers with it (changing or cleaning the value)