topic Re: Variable Directory in QlikView

Variable Directory

Anonymous — Thu, 16 Feb 2017 07:51:27 GMT

Hi at all

I created a button in a qlikview application in which, if I click on it, I can open a pdf file that i have already created and put in a specific folder on my desktop. So i used an action (Launch)...then i selected the application (Adobe) and as working directory i pasted the right one. So everything is ok.

Now i would like to create an input box in which an user could write his specific directory path and open the same pdf file (he save the pdf file in a specific folder different by mine). So i would like to do it because i want do it flexible. The user write his path in the input box, the input box is a variable (v_Directory). Then I change my directory with $(v_Directory) but it doesn’t work. Is there a way in order to do that?

Thanks

Andrea

Re: Variable Directory

sdmech81 — Thu, 16 Feb 2017 08:20:04 GMT

I think thts how it should b done.

What error u got?

Re: Variable Directory

Anonymous — Thu, 16 Feb 2017 08:26:56 GMT

This is the variable:

This is the action

When i click on the button, it said that it is not possible find the PDF file.

Re: Variable Directory

rahulpawarb — Thu, 16 Feb 2017 08:56:16 GMT

Looking at present settings everything looks OK. However, I have a query - What all different values [Ragione sociale] holds? And one more thing could you please check what value below expression will generate using Text Object?

//Text Object Expression

=$(v_Directory) & [Ragione sociale] & '.pdf'

Re: Variable Directory

Anonymous — Thu, 16 Feb 2017 09:04:17 GMT

Hi Rahul,

So i have a PDF file for any customer. All these PDF files are in a folder on my desktop. I created my visualization with qlik view and i have added a filter in order to select a specific customer. than i have also added a button because i would like to open its PDF file without go on the folder (folder is called Company).

Ragione Sociale is a dimension with the name of the customer selected by filter.

Any PDF file is saved with the name of the customer (Ragione Sociale) and .pdf

Re: Variable Directory

rahulpawarb — Thu, 16 Feb 2017 09:22:06 GMT

Would it be possible to share application with sample data files? Have you tried to print the result of expression using text object?

Re: Variable Directory

sdmech81 — Thu, 16 Feb 2017 09:26:30 GMT

HI,

When u add =$(v_Directory) this variable in text box is it giving path ryt?

And if so is it showing path similar to how it was when u hardcoded path earlier in working directory.

Just cross verify to achieve above thing bcs wt u r doing is correct method I guess..

Sachin

Re: Variable Directory

Anonymous — Thu, 16 Feb 2017 09:34:25 GMT

I created this demo.

I attached a PDF file, i used this directory:

C:\Users\user_07\Desktop\Try

So i think that you have to save this pdf file in a folder called Try and then write the new directory in the action of the botton.

I also created the Sheet with the variable. The first one (without variable) works fine, the second one no.

Re: Variable Directory

rahulpawarb — Thu, 16 Feb 2017 09:56:38 GMT

Hello Andrea,

Please follow below steps:

1. Open With Variable sheet

2. Add a Input box object; In General tab, add v_Directory to Displayed Variables and click OK

3. Enter the file path in Input box in single quotes e.g. 'E:\Rahul Pawar\My Hands On\Qlikview\Testing\ButtonDemo' (.pdf file reside at this path)

4. Click on PDF button. This will give you desired results.

P.S.: No need to change any settings present under Action tab of PDF button.

Regards!

Rahul

Re: Variable Directory

Anonymous — Thu, 16 Feb 2017 10:12:10 GMT

Thanks for your help

Re: Variable Directory

Anonymous — Thu, 16 Feb 2017 10:12:24 GMT

Thanks for your help

Re: Variable Directory

Thu, 16 Feb 2017 10:14:20 GMT

Hi,

I redesigned the text object you have used.
mostly the problem was with the working directory declaring section.

The following screen shot shows the working version of your application.

While clicking the button the PDF opens. Also in the filename I have directly given the file name.

Attached the qvw.

Regards, !

Vivek

Re: Variable Directory

rahulpawarb — Thu, 16 Feb 2017 10:28:14 GMT

Cheers,

Rahul