Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

get url in variable

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

13 Replies
Not applicable
Author

Not applicable
Author

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.

Not applicable
Author

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

Not applicable
Author

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?

Not applicable
Author

Anyone with suggestions how to solve the problem??!

Anonymous
Not applicable
Author

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.

Not applicable
Author

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.

Anonymous
Not applicable
Author

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?

Not applicable
Author

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.