topic Re: Get 'ajax Url' in a QV document in QlikView

Get 'ajax Url' in a QV document

Mon, 05 Dec 2011 16:26:34 GMT

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=ajax&param1=val1ue

Thanks by advance

Vincent

Re: Get 'ajax Url' in a QV document

Miguel_Angel_Baeyens — Mon, 05 Dec 2011 16:39:31 GMT

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=ajax&param1=val1ue', '?', 2), '&') AS Pairs
AUTOGENERATE 1;

This dummy example based on your url does the following:

The first load takes the part on the right of the "?" where the values are and
Takes each of the pairs between "&" (name=value)
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

Re: Get 'ajax Url' in a QV document

Tue, 06 Dec 2011 07:33:02 GMT

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