topic Path in QlikView

Path

bharatkishore — Wed, 08 Feb 2012 08:01:26 GMT

Hello ALL,

In text Object i gave QVwork Path.I am getting the path.I am getting as D:\RBK\NewProject\Applications.But instead of Application i want to get Text.That is D:\RBK\NewProject\Text

Can anyone say to me how to do this.I attached My application for your better understanding.

Regards,

R.Bharat Kishore

Re: Path

kaushiknsolanki — Wed, 08 Feb 2012 08:12:32 GMT

Hi,

Have a look at the application.

Regards,

Kaushik Solanki

Path

bharatkishore — Wed, 08 Feb 2012 08:14:56 GMT

Thanks A lot Kaushik.Thank you.

Regards,

R.Bharat Kishore

Path

kaushiknsolanki — Wed, 08 Feb 2012 08:20:22 GMT

Hi,

Use below expression.

=mid(QvWorkPath,1,FindOneOf(QvWorkPath,'\',SubStringCount(QvWorkPath,'\'))) &'Text'

Advantage of above one is you even if the path changes it will change the last directory name.

Regards,

Kaushik Solanki

Path

bharatkishore — Wed, 08 Feb 2012 08:26:47 GMT

Hi Kaushik,

Thank u Kaushik.In the mean time i gave expression as =SubField(Qvworkpath,'Application',1)&'Text'&;

I hope this is also correct.

Please Correct me if i am wrong.

Regards,

R.Bharat Kishore

Path

kaushiknsolanki — Wed, 08 Feb 2012 08:48:37 GMT

Hi,

Try to put this expression in textbox and check the output.

Regards,

Kaushik Solanki