topic Conditional objects in QlikView

Conditional objects

Mon, 18 Jan 2010 17:35:41 GMT

We are using section access for data reduction. In the excel sheet we use to assign who has access to what, i set a group = 1 or 4. If the group is =4 i want a certain object to appear and if group = 1 i want a different one to appear.

In the object i set conditional statement to "GROUP = 4" or for the other one "GROUP = 1" however, the problem is when you pull in the data it only pulls in 4 or 1 like it is suppose to, but the box doesn't appear unless the data is "selected"

Any thoughts?

Thanks,

Conditional objects

Mon, 18 Jan 2010 18:06:33 GMT

You could set up a Trigger (v9) or a macro to select the Group value on Open (ActiveDocument.Fields("Group").Select "*").

You could also populate a variable with your Group value in your load (Let vGroup = ?;)

Conditional objects

Mon, 18 Jan 2010 19:22:58 GMT

How might you do that if you loaded the group from a file

load

Group

from file.qvd

Conditional objects

Mon, 18 Jan 2010 20:38:50 GMT

Actually, if you only have one value in the Group field. You should be able to create a variable defined as:

=Concat(Group, ',')

That should be a list of all possible values of Group. Since Group would only have the single value based on the user, it will resolve to the Group value.

Conditional objects

Tue, 19 Jan 2010 15:35:41 GMT

Worked great, thanks for your help.