topic Re: Conditional text box in QlikView

Conditional text box

Tue, 28 Oct 2014 20:30:14 GMT

Does anyone know how I can set a text box to only display when field [Project Name] only has one value selected?

Re: Conditional text box

JonnyPoole — Tue, 28 Oct 2014 20:41:33 GMT

On the layout tab of the text box properties is a show/conditional checkbox.

Check that.

Then enter a condition like: getselectedcount( [Project Name]) = 1

you could also do getpossiblecount( [Project Name]) = 1

this would handle the situation where a user may not have selected a project name, but through other selections, there is only one (white) project name possible anyways.

Re: Conditional text box

Tue, 28 Oct 2014 20:43:46 GMT

Jon saves my day again!

Re: Conditional text box

JonnyPoole — Tue, 28 Oct 2014 20:44:36 GMT

hurray !

Re: Conditional text box

its_anandrjs — Tue, 28 Oct 2014 20:46:40 GMT

Yes use GetSelectedcount() function for this in the layout properties of the text object in Conditional write expression

=Getselectedcount( [Project Name]) = 1

See snap for that

Regards

Anand