topic Re: Field Selections in QlikView

Field Selections

Mon, 17 Feb 2014 15:18:31 GMT

Hi All,

I have a user_name field with all the users and sensitive_data_flag with 0 or 1 against each user_name.

And vUser variable that fetches user_name from OSUSER.

i will get user_name from vUser and once i get user_name corresponding sensitive_data_flag should be selected

Requirement is When i click on a button i want sensitive_data_flag to be selected.

Please help me with this.

I have attached QVW

Thanks & Regards,

Keerthi

Re: Field Selections

Mon, 17 Feb 2014 15:27:50 GMT

Can you explain further what you mean? You want a button that displays a user's sensitive data flag when they're logged in? The requirement is unclear.

Re: Field Selections

giakoum — Mon, 17 Feb 2014 15:27:55 GMT

Hi,

Use Trigger for this.

Go to Document properties-->Triggers tab-->FieldEvent Triggers-->select the user field-->Click on the add action button under on select.

click Add button-->Use Select Possible-->Use the sensitive field name

Re: Field Selections

Anonymous — Mon, 17 Feb 2014 15:29:31 GMT

The button have to use action "select in field", the field is sensitive, and the search string:

=only({<user={$(vUser)}>} sensitive)

Re: Field Selections

sivarajs — Mon, 17 Feb 2014 15:30:18 GMT

If you are using QV11then go to button actions , select in field then give fieldname and flag as 1.

Else try the attached

Re: Field Selections

Tue, 18 Feb 2014 03:48:02 GMT

When i click on a button based on users sensitive data flag, field sensitive data flag should be selected.

Got the solution =only({<user={$(vUser)}>} sensitive)

vUser fetches the user name from OSUSER and checks for sensitive field. I have used button with select in field to select the sensitive field.