Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
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

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
New 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 ...