topic With variable load in QlikView

With variable load

Anonymous — Fri, 14 Jan 2011 13:13:35 GMT

Hello ..

I have an application that imports files that QVD in its extension has the user name.

When multiple users are I use (*) in the extension.

LOAD *
FROM
(QVD);

When I load, mind all the files of all users.

What I need is that when making the charge, that (*) is replaced by a variable that points within the application only the user name that must be imported.

I have an application in the field with the name of the users.

LOAD *
FROM
(QVD);

So, this application could run as follows:

In the application, select the user field through a filter object and then do the load. At this point the script should read the variable that is pointing the user field that was selected.

Does anyone have an idea how to do this?

Thanks.

With variable load

Fri, 14 Jan 2011 13:35:46 GMT

Hi Washington,

There is a function named FileName() which will give you the name of the QVD . You can use this to solve the same.

e.g

RND:
LOAD Date,
Code,
sales,
Filename() as Test

FROM
..\UK001_UserName.qvd
(qvd);

Regards,

Ravi

With variable load

sparur — Fri, 14 Jan 2011 13:38:11 GMT

Hello,

You should Create variable vUser with value like this:

=only(YourUserFieldName)

so after this, when user select one value in this field (filter, listbox) - this variable will be change.

and you can use it in the script:

LOAD *
FROM
(QVD);