topic Re: conditionally hide/show a text box based on field values without its selection in that field in QlikView

conditionally hide/show a text box based on field values without its selection in that field

sayanpwc — Mon, 04 Jun 2018 13:24:20 GMT

Hello team,

Facing an issue.

I want to hide /show a text box based on a filter value.

for ex: while opening the sheet my field 'Region' shows two values in the list box : north and east,west,south

Now i want to show a text box if the field value is north/west and hide it if the value is east/south. But without selection in the filter.

How can i do this?

Re: conditionally hide/show a text box based on field values without its selection in that field

sunny_talwar — Mon, 04 Jun 2018 13:27:28 GMT

If both the values are possible then how do we hide or show anything? You are not selecting one or the other? or is this based on selection in another field which leads to only one value of Region?

Re: conditionally hide/show a text box based on field values without its selection in that field

sayanpwc — Mon, 04 Jun 2018 13:31:12 GMT

SEE THis comes from section access. for example one user has access to North and south Region.

In dashboard i have four text boxes for North,South,east and west instead of the region field. ( There is a reason ).

now for example user A has only access to North and East region. so when user opens this app he should be able to see only two text boxes of North and east. How to achieve this?

Re: conditionally hide/show a text box based on field values without its selection in that field

kfoudhaily — Mon, 04 Jun 2018 13:40:26 GMT

Hello,

I think you should use triggers to open an object on a sheet when it is opened.

here is how you need to configure you sheet:

You go the "settings" menu, "sheet properties", and then "Triggers" menu

on sheet activatin, clic "add action"..

there's more than one way to do this; either to use the activate object option

or you can use to assign a value to a variable depending on the condition you are requiring.

Hope it's helpfull.

regards

Re: conditionally hide/show a text box based on field values without its selection in that field

sunny_talwar — Mon, 04 Jun 2018 13:47:31 GMT

May be just check like this in conditional condition for North

SubStringCount(Concat(DISTINCT '|' & Region & '|'), 'North') = 1

and do this for all other Regions

Re: conditionally hide/show a text box based on field values without its selection in that field

sayanpwc — Mon, 04 Jun 2018 15:37:15 GMT

Thanks Sunny!! It worked!!