Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

Conditional text box

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

1 Solution

Accepted Solutions
Employee
Employee

Re: Conditional text box

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.

View solution in original post

4 Replies
Employee
Employee

Re: Conditional text box

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.

View solution in original post

Not applicable

Re: Conditional text box

Jon saves my day again!

Employee
Employee

Re: Conditional text box

hurray !

Highlighted

Re: Conditional text box

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

LayoutBox.png


Regards

Anand