Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Josh_Good
Employee
Employee

Passing Parameters in a URL and Document Chaining

This videos describes how to pass parameters in a URL and how to leverage this techinque to chain documents when using AJAX.

The genral syntax is as follows:

http://myserver//QvAJAXZfc/opendoc.htm?document=DocumentName.qvw&host=Local&select=LB01,Value

It is also possible to us a similar technique to go directly to a specific sheet within a document using the sheet parameter.

e.g. http://myserver//QvAJAXZfc/opendoc.htm?document=DocumentName.qvw&host=Local&sheet=SH01

http://youtu.be/ESSvm_xMTlE

100 Replies
qlikviewwizard
Master II
Master II

Good document. Thank you for sharing.

Not applicable

Hi Christ,

  I used the logic u mentioned:"if the value in the list contains a space or comma,we have to replace it with '?'".

  It is working fine.However in the current selections window the value is appearing with ? in the place of space.

For Example:

  In Current selection box,Happy World is shown as Happy?World.

But i need Happy World in current selection window

  Is there anyway i can get my actual value in current selection window even though using ? in the place of space in url

mishraamit2485
Creator
Creator

Hi Josh,

In this approach I'm having one issue, suppose u r in App2 and let say we have 3 sheets, now when you hide all the three you will seeing the sheet 1 by default 2 and 3 will be hidden (we have to hide the sheets to achieve this)..

In such cases when you do the clear (App2) irrespective of your active sheet it will go to Sheet1, so if you are doing some analysis on sheet 2 the moment you hit the clear you will be transferred to sheet 1

Not sure how to attach the app got work around but if you go though this link(https://community.qlik.com/thread/162286) you will get same app with the same problem but no solution.

So I think your 1st approach would be better.

Thanks

Anonymous
Not applicable

Hi Josh,

       In URL,Replacing space with single wildcard character '? ' - This logic worked for me.However in the current selection box,i am getting the value with space as value with '?'.

For Example:            "Happy World" is showing as "Happy?World"

How can we handle it?

Thank You

Not applicable

Hi Josh

            For the logic " In your expression that generates the URL use the Replace function to replace spaces with a single character wildcard '?'.:.The logic is working correctly, However in Current selection box of qlikview the value with space is showing the value with '?'

For Example:

"Happy World"  as "Happy?World"

How can we can handle this issue?

Thank You

Josh_Good
Employee
Employee
Author

Hi Vijayalakhmi,

This is QlikView just telling you the truth.  The selection is actually being made that way so it is indicating that in the Current Selections box.   If you want to get rid of it then you can add use the "Select Possible" action to the field.  This may be difficult to execute well because you are doing it across apps so you will likely need to have the Select Possible action trigger whenever the field is changed.  This could be very annoying when someone starts using the app beyond just linking to it.

-Josh

Qlik

ChristofSchwarz
Partner Ambassador
Partner Ambassador

You can put Happy World in double quotes and by this avoid using the ?-wildcard

http://localhost/QvAJAXZfc/opendoc.htm?document=xxxx.qvw&select=LB88,"Happy%20World"

All the following syntax would work:

&select=LBxx,(Value1|Happy?World)

&select=LBxx,("Value1"|"Happy World")  .. note in this syntax you must put all values in quotes or none

&select=LBxx,Value1,"Happy World" ... in this syntax you can mix quoted and unquoted values

Anonymous
Not applicable

That works like a magic.Thank you so much

nehasaxena
Creator II
Creator II

Hi Josh,

I have a requirement to pass the user selections from one Qlikview report to another report in access point. Your Post helping me here. But I am facing issue while generating syntax for passing values from multiple objects.

http://myserver//QvAJAXZfc/opendoc.htm?document=DocumentName.qvw&host=Local&select=LB01,GetFieldSele...)

The above URL Works fine for me but not works for multiple objects, Could you please help me in getting the syntax for that.

It would be great help for me.

Thanks.

Best Regards,

Neha

Josh_Good
Employee
Employee
Author

Hi Neha,

You can just follow the same syntax so it would be:

......DocumentName.qvw&host=Local&select=LB01,Value&select=LB02,Value

I did noticed that you are using the GetFieldSelections function.  This could be the route of the issue you are having. You need to make sure it is returning the values in the correct format, which is:

(Value1|Value2|Value3...)

This could mean you need a more complex expression.  Something like:

='......DocumentName.qvw&host=Local&select=LB01,(' & Concat(Distinct(FieldName1, '|') & ')&select=LB02,(' & Concat(Distinct(FieldName2, '|') & ')


The idea here is to result in an expression that returns this:

......DocumentName.qvw&host=Local&select=LB01,(Value1|Value2|Value3)&select=LB02(Value5|Value6|Value7)

I hope this helps.  Please mark my response as correct to helpful if it does so other can find answers quickly.

-Josh

Qlik