topic Re: Hide and Show object on Field Selection in QlikView

Hide and Show object on Field Selection

alkesh_sharma — Tue, 08 Jul 2014 12:28:51 GMT

Hello,

I need to Hide and show an object based on selection on a particular field.

Example:

Object X should Show only if there is a selection in Y field else it will not show.

Re: Hide and Show object on Field Selection

ThornOfCrowns — Tue, 08 Jul 2014 12:35:48 GMT

Look at the Conditional option of the object, then at the help file for GetFieldSelections()

Re: Hide and Show object on Field Selection

mseeck75 — Tue, 08 Jul 2014 12:38:13 GMT

Hi Alkesh,

you can do that by using variables. If you select an field then you can configure a trigger for the field selected that stores the ID of the selected field into the variable. In the layout condition of the object then you can use this variable to showing that object.

Rgds

matthias

Re: Hide and Show object on Field Selection

tresB — Tue, 08 Jul 2014 12:40:35 GMT

Conditional expression should be something like:

=GetSelectedCount( YField)

Re: Hide and Show object on Field Selection

Tue, 08 Jul 2014 12:57:07 GMT

Attaching the example, you need to use the condition in properties->Layout->Show->Conditional

Re: Hide and Show object on Field Selection

mseeck75 — Tue, 08 Jul 2014 12:58:28 GMT

Hi Alkesh,

If you want to show an object depending on a single selected field the you have also the opprtunity to use the substringcount function like this:

=SubStringCount(Concat(YourField,'|'), 'YourSearchstring')

Use this expression in the show condition of the object's layout properties.

Rgds

matthias