Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks by advance
Vincent
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:
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
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