topic Re: Passing a value in a URL to restrict data in QlikView

Passing a value in a URL to restrict data

Fri, 21 Sep 2012 20:01:52 GMT

Hi,

I am trying to create a URL that will pass a value so that the QVW will be restricted on that value. See example:

http://nts-qlikviewd1/QvAJAXZfc/opendoc.htm?document=1Link%20Dashboard%20TEST.qvw&host=Local&select=Document\LB57, 24

What’s happening is that it seems to be doing a fuzzy search. It is restricting the document to values 24, 240, 241, 242, etc. I need it to restrict the document to 24 only.

In my document I have a list box that has this field. I tried changing the properties of the default search mode but didn’t have any luck.

Is there something I need to specify in the URL so that it will only restrict on 24?

Thanks!

Re: Passing a value in a URL to restrict data

swuehl — Fri, 21 Sep 2012 21:32:52 GMT

Try using something like "=FIELD=24" as value that you pass, like for this demo:

http://eu.demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs/QlikView%20Developer%20Toolkit.qvw&host=Demo11&select=LB05,%22=Month=1%22

Hope this helps,

Stefan

Re: Passing a value in a URL to restrict data

Mon, 24 Sep 2012 15:39:04 GMT

Thanks for your response. Your example works well however, when I apply it to mine it doesn't behave the way I would expect.

Here is my url based on your example:

http://nts-qlikviewd1/QvAJAXZfc/opendoc.htm?document=1Link%20Dashboard%20TEST.qvw&host=Local&select=LB57,%22=CUST_NO=394%22

If I change the CUST_NO from 394 to 24, my document retains the current selection and does not filter on 24. It stays filtered on 394. Only after I clear the current selection and then re-paste the url will it filter on CUST_NO 24.

What I need to do is create a url for each customer which will then be incorporated in to our CRM. Is there a way to force it to not retain the current selection?

Re: Passing a value in a URL to restrict data

swuehl — Mon, 24 Sep 2012 15:47:35 GMT

Your example shows no fully qualified URL and I assume I can't open anyway.

If you need to disregard current selection, you can try something like (using my sample to test):

http://eu.demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs/QlikView%20Developer%20Toolkit.qvw&host=Demo11&select=LB05,%22=only%28{1}Month%29=5%22

Hope this helps,

Stefan

Re: Passing a value in a URL to restrict data

Mon, 24 Sep 2012 16:04:07 GMT

This works. Thanks so much for your help.

Re: Passing a value in a URL to restrict data

Wed, 26 Sep 2012 13:07:42 GMT

Using this url, is it possible to also include a specific sheet?

http://nts-qlikviewd1/QvAJAXZfc/opendoc.htm?document=1Link%20Dashboard%20TEST.qvw&host=Local&select=LB57,%22=only%28{1}CUST_NO%29=24%22

I'm noticing that when I click on this url it does not consistently go to sheet I was expecting.

Thanks in advance for any help.

Re: Passing a value in a URL to restrict data

swuehl — Wed, 26 Sep 2012 15:52:08 GMT

I think you need to use

&sheet=SH01

as URL parameter to open sheet SH01 (look up the appropriate sheet ID in sheet properties) on open.

http://eu.demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs/Help%20Desk%20Management.qvw&host=Demo11&sheet=SH06

Re: Passing a value in a URL to restrict data

Tue, 04 Dec 2012 08:15:36 GMT

Hi there,

I have a simlar requirement.

I want a selection made on the field [Account Number] in one document to be passed to another document having the same field name and values.

Is this possible through URL.. or is it only possible using list boxes.

Re: Passing a value in a URL to restrict data

Thu, 21 Feb 2013 17:11:53 GMT

Hi Stefan,

I have a similar requirement. I found your reply really useful. I am trying to select a field called as 'Patient ID Compare' with just the value 3.

I tried the following but nothing is getting selected now. Is it because your field name did not have spaces and mine has? I tried to put square brackets around it but it isn't working. Would you happen to know what am I doing wrong?

http://167.219.4.171/QvAJAXZfc/opendoc.htm?document=HIMSS%20Demo_v21_021913_EST.qvw&host=Local&sheet=SH26&select=LB956,%22=only({1}[Patient%20ID%20Compare])=3%22

Re: Passing a value in a URL to restrict data

Tue, 10 Mar 2015 15:28:53 GMT

Hi Everyone,

Anyway we can do this with Qlik Sense ??? I have licenses and server installed.

Thanks!