Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Get 'ajax Url' in a QV document

Hi

I need to get the url in my Qlikview document to catch the parameters of it

I failed to resolved my problem

May be somebody have do it and can help

my url looks like

http://myServer.myDomain.fr/xxxxxx/accessPoint.aspx?open=&id=Local%7CMyFolder/myDocument.qvw&client=...

Thanks by advance

Vincent

Tags (1)
2 Replies
MVP
MVP

Re: Get 'ajax Url' in a QV document

Hi Vincent,

SubField() will do, and a precedent load will help as well:

Data:

LOAD SubField(Pairs, '=', 1) AS Name,

     SubField(Pairs, '=', 2) AS Value;

LOAD SubField(SubField('http://myServer.myDomain.fr/xxxxxx/accessPoint.aspx?open=&id=Local%7CMyFolder/myDocument.qvw&client=...', '?', 2), '&') AS Pairs

AUTOGENERATE 1;

This dummy example based on your url does the following:

  1. The first load takes the part on the right of the "?" where the values are and
  2. Takes each of the pairs between "&" (name=value)
  3. Then the preceding load takes the part on the left of the "=" as the parameter name and the right as the parameter value.

This will work regardless the number of parameters and urls you have, resulting in three fields, Name, Value and Pairs.

Is this what you are looking for?

Miguel

Not applicable

Re: Get 'ajax Url' in a QV document

Hi Miguel

What i need is to get the url in a QV document

Something like  getUrl

But your response will help me to get the parameters

Thanks

Vincent

Community Browser