Passing a value in a URL to restrict data

[#1]

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=..., 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!

[swuehl]

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

Hope this helps,

Stefan

[#3]

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=...,%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?

[swuehl · Accepted solution]

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

Hope this helps,

Stefan

[#5]

This works.  Thanks so much for your help.

[#6]

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

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.

[swuehl]

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

[#8]

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.

[#9]

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

[#10]

Hi Everyone,

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

Thanks!