topic Re: get url in variable in QlikView

get url in variable

Thu, 22 Nov 2012 13:50:10 GMT

Hello my dear fellow qlikview experts

I need your help !

I want to make a variable which catches my url in a variable from my accespoint due to i want to make some urlbased security.

EG.

I have this url: http://localhost/QvAJAXZfc/opendoc.htm?document=QVTEST.qvw&host=Local from my accesspoint when i open QVtest.qvw

In my document i have a textbox with a variable which is hardcoded to: http://localhost/QvAJAXZfc/opendoc.htm?document=QVTEST.qvw&host=Local

But what i get a login parameter so my url becomes to this instead:

http://localhost/QvAJAXZfc/opendoc.htm?document=QVTEST.qvw&host=Local&Kunde=Hansi

How can i make my textbox show this by a variable then? How can i catch my url, even if it changes...?

Re: get url in variable

Thu, 22 Nov 2012 14:10:31 GMT

you mean you want your textbox show:

http://localhost/QvAJAXZfc/opendoc.htm?document=QVTEST.qvw&host=Local

even if your url is :

http://localhost/QvAJAXZfc/opendoc.htm?document=QVTEST.qvw&host=Local&Kunde=Hansi

am i right?

Re: get url in variable

Thu, 22 Nov 2012 14:18:29 GMT

No!!

I want it to be able to change!! I want it to be dynamic!

If i log into accespoint a click on my first document QVtest.qvw - Then my textbox will show

http://localhost/QvAJAXZfc/opendoc.htm?document=QVTEST.qvw&host=Local

This is my standard URL when click on QVtest.qvw

- But if i want to make my url as a LOGIN so when i click on QVtest.qvw it goes to

http://localhost/QvAJAXZfc/opendoc.htm?document=QVTEST.qvw&host=Local&Kunde=Hansi

Kunde = Customer

Hans = Customers name

I want my text box change whether is standing behind my orginal url. So when Hans log in he will only be avaiable to see his own data. Cause it is his own url. It could also have been &Kunde=Diana - Then it should show that.

Re: get url in variable

Thu, 22 Nov 2012 14:35:11 GMT

This seems like an attempt to circumvent security protocols? Why no use section access? Are the users in your domain?

Re: get url in variable

Thu, 22 Nov 2012 14:37:12 GMT

No no users in my domain. All users will come from external and login to a controlpanel - where they should be able to through an iframe to see their qlikview report, without logging in twice! Therefore i need the url based security. And therefore i need to bring down the url in a variable..

or is there other ways?

Re: get url in variable

Fri, 23 Nov 2012 07:38:49 GMT

Anyone with suggestions how to solve the problem??!

Re: get url in variable

Anonymous — Fri, 23 Nov 2012 07:50:54 GMT

If you add a Text Object with the function: =OSUser()

What does it say as username when Hans or Diana log in?

It sound like if your authentication system supports passing the authenticated username in the HTTP header you could use this with QlikView to remove the need of authenticating twice and it should be the equivalence of NTNAME in Section access so you can use that to reduce data based on logged in user.

Re: get url in variable

Fri, 23 Nov 2012 08:06:16 GMT

Im not sure i totally understand you?

I have not set an login for Hans og Diana.

1. I have 2 different users - Hans and Diana

2. Hans and Diana logs in to a controlpanel

3. Through the controlpanel they can access qlikview through an iframe (they should access without password, due to its not userfriendly to have to logins.) I will make the access in the url by some paramaters like &kunde=Hans

4. How can i make qlikview understand that it is HANS who is logged in and not Diana for an example?

5. And how do i do, so i only shows HANS data.

Re: get url in variable

Anonymous — Fri, 23 Nov 2012 08:12:07 GMT

For point 2, "Hans and Diana logs in to a controlpanel", how do they login?

Are you using an existing system like Tivoli Access Manager, or are you creating your own login mechanism?

Re: get url in variable

Fri, 23 Nov 2012 08:17:10 GMT

ITs my own login mechanisme

But the thing I would like is that they would be known by qlikview on the last parameter in the url. eg &kunde=Hans.

I could then at some point maybe create a new dimension called DimSecurity, wherein i will put the customerid and a guid.

My controlpanel will make the parameter, but i just need qlikview how to understand that its a user, who can only see his own data.

Re: get url in variable

Fri, 23 Nov 2012 08:39:05 GMT

Basically i just need a variable which can tell me what my url is - even if it changes. And then i need to make a selection on that, because then i can only show data for that users, cause the URL is unique.

Re: get url in variable

Anonymous — Fri, 23 Nov 2012 08:49:22 GMT

I understand what you're trying to do but I don't think there's a good way of natively grabbing the URL and it feels like it could be easily exploited if someone changes the name in the URL for example.

It sounds like using web tickets for authentication might be more up to the task. See more info here:

http://community.qlik.com/docs/DOC-3614

Re: get url in variable

Fri, 23 Nov 2012 09:02:35 GMT

You cant crab the URL, cause it is made by an guid. So you will never guess the others url

Re: get url in variable

Fri, 23 Nov 2012 09:11:09 GMT

Its not able to be done by macros eg. Jscript or VBscripting??