Dynamically UserId should apply to path loaction

jagannalla — Wed, 22 Jun 2011 05:29:27 GMT

Hi,

- I had provided authentication to my qvw file with following code:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD

ADMIN, USER, USER

];

Section Application;

- When i'm opening it will ask userid and password. After login i want to see userid for that i had taken qvw function " =qvuser() ". Now it shows the login userid in text object.

- Now i'm trying to store text file in one folder and the FolderName is UserId(i.e., USER ).

- Previously my code for store the txt file is like this.

Table:

LOAD A,B

AUTOGENERATE 1;

STORE VariableTable INTO D:\Examples\USER\File.txt (txt);

- Now i want to change the folder name dynamically as per login userid. For this i stored login userid in one variable(i.e., vUser=qvuser())

Table:

LOAD A,B

AUTOGENERATE 1;

STORE VariableTable INTO D:\Examples\$(vUser)\File.txt (txt);

- It shows the following error while reload

- How can i overcome this.

Dynamically UserId should apply to path loaction

Anonymous — Wed, 22 Jun 2011 05:34:12 GMT

DId you use SET to set the variable? In that case try LET

Dynamically UserId should apply to path loaction

jagannalla — Wed, 22 Jun 2011 06:33:27 GMT

Jonhannes,

Ya it's working with LET, Previously i tried with SET.

Thanks a lot...

topic Dynamically UserId should apply to path loaction in QlikView

Dynamically UserId should apply to path loaction

Dynamically UserId should apply to path loaction

Dynamically UserId should apply to path loaction