topic Re: How to get the path of your QlikView document in QlikView https://community.qlik.com/t5/QlikView/How-to-get-the-path-of-your-QlikView-document/m-p/808059#M285245 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333330154419px;">What if I just want everything before '\TestApp.qvw'? How can I do this dynamically using the string functions? </SPAN></P></BODY></HTML> Mon, 02 Feb 2015 15:01:33 GMT 2015-02-02T15:01:33Z How to get the path of your QlikView document https://community.qlik.com/t5/QlikView/How-to-get-the-path-of-your-QlikView-document/m-p/808055#M285241 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I wanted to know how I would go about getting the folder/file location of a QlikView document dynamically using the string functions Subfield. </P><P></P><P>So for example:</P><P>My Doc is called TestApp.qvw</P><P>The document resides in the following folder: C:\Users\JoeBloggs\TestApp.qvw</P><P></P><P>I want to be able to use a string function to get the full folder location in which my QlikView file resides in dynamically. </P><P></P><P>I know there is a solution which I have used but forgotten how is it coded. </P><P></P><P>Thanks</P></BODY></HTML> Mon, 02 Feb 2015 14:44:37 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-path-of-your-QlikView-document/m-p/808055#M285241 2015-02-02T14:44:37Z Re: How to get the path of your QlikView document https://community.qlik.com/t5/QlikView/How-to-get-the-path-of-your-QlikView-document/m-p/808056#M285242 <HTML><HEAD></HEAD><BODY><P>The function DocumentPath() returns the full path as a string.</P></BODY></HTML> Mon, 02 Feb 2015 14:52:21 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-path-of-your-QlikView-document/m-p/808056#M285242 quwok 2015-02-02T14:52:21Z Re: How to get the path of your QlikView document https://community.qlik.com/t5/QlikView/How-to-get-the-path-of-your-QlikView-document/m-p/808057#M285243 <HTML><HEAD></HEAD><BODY><P>DocumentPath() returns a string with the full path of the dopcument</P></BODY></HTML> Mon, 02 Feb 2015 14:57:06 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-path-of-your-QlikView-document/m-p/808057#M285243 alexandros17 2015-02-02T14:57:06Z Re: How to get the path of your QlikView document https://community.qlik.com/t5/QlikView/How-to-get-the-path-of-your-QlikView-document/m-p/808058#M285244 <HTML><HEAD></HEAD><BODY><P>What if I just want everything before '\TestApp.qvw'? How can I do this dynamically using the string functions? </P></BODY></HTML> Mon, 02 Feb 2015 15:01:19 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-path-of-your-QlikView-document/m-p/808058#M285244 2015-02-02T15:01:19Z Re: How to get the path of your QlikView document https://community.qlik.com/t5/QlikView/How-to-get-the-path-of-your-QlikView-document/m-p/808059#M285245 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333330154419px;">What if I just want everything before '\TestApp.qvw'? How can I do this dynamically using the string functions? </SPAN></P></BODY></HTML> Mon, 02 Feb 2015 15:01:33 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-path-of-your-QlikView-document/m-p/808059#M285245 2015-02-02T15:01:33Z Re: How to get the path of your QlikView document https://community.qlik.com/t5/QlikView/How-to-get-the-path-of-your-QlikView-document/m-p/808060#M285246 <HTML><HEAD></HEAD><BODY><P>this is what you need:</P><P></P><P><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Mid</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DocumentPath</SPAN><SPAN style="font-size: 8pt;">(), 1, </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">FindOneOf</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DocumentPath</SPAN><SPAN style="font-size: 8pt;">(), '\', -1)) </SPAN></P></BODY></HTML> Mon, 02 Feb 2015 15:05:20 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-path-of-your-QlikView-document/m-p/808060#M285246 alexandros17 2015-02-02T15:05:20Z