Variable Directory

[Anonymous]

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

[sdmech81]

I think thts how it should b done.

What error u got?

[Anonymous]

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.

[rahulpawarb]

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'

[Anonymous]

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

[rahulpawarb]

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

[sdmech81]

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

[Anonymous]

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.

[rahulpawarb · Accepted solution]

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

[Anonymous]

Thanks for your help