topic Re: Transfer external parameter by section access. in QlikView

Transfer external parameter by section access.

Mon, 09 May 2011 12:55:37 GMT

I have a lot of parameters which want to be transfered to qvw. I want to transfer them by section access.

section access;

load USERID, ACCESS, link from a.xls.....

section application;

load link from a.xls;

load A, B, parameter1, parameter2 ....

I think if a user login with a useraccount. I can get the field of parameter1, 2.... Then I set the parameters to qlikview varibles in action(OnActiveSheet)

Every thing same to be OK. In trigger page(OnActiveSheet)

action 1: select field A in value 'link' ------ A = link

action 2: set varable : v1=parameter1

action 3: set varable : v2=parameter2

action 4: set varable : v=B

And now I can use varables in my QV file. BUT the fact is THIS IS NOT WORK WELL. Who can help and give me some advice on this. thank you .

Transfer external parameter by section access.

Mon, 09 May 2011 23:35:23 GMT

I wanna varable set in OnActiveSheet action. But I set up qvw file, it does not work. If need, I can upload my file.

Re: Transfer external parameter by section access.

erichshiino — Tue, 10 May 2011 00:41:25 GMT

Hi, I don't think you can send some parameters directly.

So I created a data island with the parameters and used section access to reduce it. So each user will only get one set of parameters.

After that, I created the macros using the values on the fields.

I hope the sample app can help you.

To open the App use:

USER: A

Password: A

USER: B

Password: B

USER: C

Password: C

Regards,

Erich

Transfer external parameter by section access.

Tue, 10 May 2011 07:07:35 GMT

Hi Erich,

Thank you for your reply.

It works, but not reach my demand.

In your example file , I can trigger the action by click another sheet. I want to set the varible when document first opened without any user click or select.

So I try to set document trigger onopenaction to open a certain sheet when document opened everytime. And set actions in OnActiveSheet to make select field and set varibles. But CANNOT work. I 'm confused about this. Please help me. Thank you.

Transfer external parameter by section access.

Tue, 10 May 2011 07:19:32 GMT

Hi.

Set trigger on Change Other Variable with content "=now(1)"

Transfer external parameter by section access.

Tue, 10 May 2011 07:29:38 GMT

Hi where is on Change Other Variable?

Transfer external parameter by section access.

Tue, 10 May 2011 07:35:34 GMT

In document propertis on sheet Variables create variable with name "aaaa", With value "=now(1)"

In document propertis on sheet Trigger set trigger OnChange for variable "aaaa". This trigger

action 1: select field A in value 'link' ------ A = link

action 2: set varable : v1=parameter1

action 3: set varable : v2=parameter2

action 4: set varable : v=B

Transfer external parameter by section access.

Tue, 10 May 2011 07:48:48 GMT

I think I know your idea. If I set a variable to =now(1) , the qv will call the action every second. I think it will slow down the system speed. I will try this may be set to =now(2) is better. I'll try it later.

Transfer external parameter by section access.

Tue, 10 May 2011 08:03:28 GMT

Hi,

May I know why do you want to set those parameters to another variable when you can directly use those paramaters? Do you want to use those parameters for hiding a sheet or chart?

You need to transfer the parameters through section access.

For example, you are using P1 as a parameter field for hiding a sheet and you have 1 as a value for user A and 0 as a value for user B. You can directly use the parameter field and its value. You need to goto sheet properties, then goto general tab, then goto the show sheet, select conditional and write sum(P1)=1. When the user A logs in the sheet will be displayed but it will be hidden for user B.

Hope you can now figure out how to use these parameters directly.

Hope this answers your query else let me know

Best Regards,

Sajeevan

Transfer external parameter by section access.

Tue, 10 May 2011 08:59:52 GMT

Hi Sajeevan, I don't transfer parameter to variable for hiding a sheet but other purpose. I have a table with several fields( ID, City, State, ........). When a user login as John for example, I want QV 'remember' John 's ID, City , State , and transfer these to variable. And then I can use these variable in set analysis expression. Thank you and hope your reply.

Transfer external parameter by section access.

Tue, 10 May 2011 09:01:45 GMT

Hi, I try =now(1) it works but =now(2) is not work because of the value do not change after document opened. But now(1) will lose performance. Have a better idea ? Thanks:)

Transfer external parameter by section access.

Tue, 10 May 2011 09:11:15 GMT

I need either a sample QVW file or your database structure to help you further. I have done similar work using the Section access. The section access will reduce the data as soon as the user logs in. In order to do this you need to use a linking variable in your tables.

Re: Transfer external parameter by section access.

erichshiino — Tue, 10 May 2011 11:05:06 GMT

Hi, I put that on OnActiveSheet as you asked.

Now I changed it to document onOpen Action (settings-> Document Properties -> Triggers)

Was it the reason it didn't solve your problem?

Re: Transfer external parameter by section access.

Tue, 10 May 2011 12:14:10 GMT

Hi,

Thanks for sharing this example file. Hope you don't mind me changing it a bit.

Please find attached the same file with some minor changes to demonstrate how the automatic data reductions happens when a user logs in. I have added an ADMIN user as "AD" and the password as "AD" (This is absolutely critical) who will have access to all countries. All other users access I have changed as USER. The users will have access to the data for the country they have been associated. I have also added COUNTRY as a parameter to the team table which will automatically reduce the data depending who has access to which country.

I have added a text object which will give the total population to demonstrate how the parameters can be directly used rather passing to another variable though actions. This will be displayed only for user A and will be hidden for everyone else. This way these parameters can be used for all other calculations.

Please have a look at it and let me know.

Best Regards,

Sajeevan

Re: Transfer external parameter by section access.

Tue, 10 May 2011 23:35:00 GMT

hi Sajeevan and Erich, Thank you for your example files(v1 and v2). I have edited the file in the attachment(version 3). I change the LinkTable and FactTable and these two table have no relation in QV data structure because I don't want to reduce data in FactTable. I just want to "transfer" the parameters for further function. Ofcause I can create a clone table named FactTable2 which is used only for transfer and get parameters. But if I use the clone table, the QV database will became to redundance and "fat". I have almost a eighty million records, so I want to just "transfer".

Re: Transfer external parameter by section access.

Wed, 11 May 2011 06:43:31 GMT

Hi,

You don't need to use trigger for setting variables. You can use [settings] [variable overview] menus and set the variables like in picture below.

Please find attached the modified QVW file for checking this out. Hope this is what you wants.

Best Regards,

Sajeevan

Transfer external parameter by section access.

Thu, 12 May 2011 05:01:27 GMT

Hi Sajeevan , Thank you for you patient. I notice that in your post you set variable values directly in =param1. It works, but the variable value will change when unselect the value or select other value in the field. What I want to do is "remember" the value whatever any select or unselect, the varibale will remain the same value. Do you have any idea about this?

Transfer external parameter by section access.

Thu, 12 May 2011 08:02:26 GMT

Yes, it will change if you allow the user to select the parameters which are controlling the variable values hence don't allow the user to select the parameters.

Is it required to allow the users to select another value within the parameters?

Transfer external parameter by section access.

Thu, 12 May 2011 09:09:02 GMT

Yes, it is. I only want variable "remember "parameters . After the variable get the value, the user can select any other in table. In a word, I want the variable get the parameter when the document opened in the first time, after that I don't want the value changed.

Transfer external parameter by section access.

Thu, 12 May 2011 10:23:26 GMT

In order to keep the values in place, users should not be left to select the same parameters which are used for passing parameters. You can create another table with a different field name for them to choose a different parameter