Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: Showing Text box based on Selection

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
Highlighted
Not applicable

Re: Showing Text box based on Selection

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

Highlighted
Not applicable

Re: Showing Text box based on Selection


Actually Patient Names are text(A,B)

Highlighted

Re: Showing Text box based on Selection

Try this

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


Let me know

View solution in original post

Highlighted
Not applicable

Re: Showing Text box based on Selection

GetSelectedCount should still work I think.

Highlighted
Not applicable

Re: Showing Text box based on Selection


Thanks Alessandro. Its working.

Highlighted
Contributor III
Contributor III

Re: Showing Text box based on Selection

You can use match function

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

returns 2 if M = Feb

returns 0 if M = Apr or jan

Highlighted

Re: Showing Text box based on Selection

Could you please mark my answer

Really thank you ...