Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Showing Text box based on Selection

Need to hide the chart based on selection in list box.

I had a text box, showing value. I had list box showing patients(I have 6 patients').

If 1 and 2 patients are selected only, text box should not be shown. For3, 4,5,6, text box should be shown.

I wrote in Text Box->Properties-Layout-Show

Conditional

 

GetFieldSelections([Patient Name])<>'1'

its working

How can I do for both 1and 2 patients?

Please reply ASAP

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

Try this

Index(GetFieldSelections([Patient Name]),'1') = 0 and Index(GetFieldSelections([Patient Name]),'2')=0


Let me know

View solution in original post

7 Replies
Not applicable
Author

Use if(GetSelectedCount([Patient Name]) > 2, 1, 0) in your conditional show expression.

Not applicable
Author


Actually Patient Names are text(A,B)

alexandros17
Partner - Champion III
Partner - Champion III

Try this

Index(GetFieldSelections([Patient Name]),'1') = 0 and Index(GetFieldSelections([Patient Name]),'2')=0


Let me know

Not applicable
Author

GetSelectedCount should still work I think.

Not applicable
Author


Thanks Alessandro. Its working.

sarvjeet
Contributor III
Contributor III

You can use match function

match( M, 'Jan','Feb','Mar')

returns 2 if M = Feb

returns 0 if M = Apr or jan

alexandros17
Partner - Champion III
Partner - Champion III

Could you please mark my answer

Really thank you ...