Discussion board where members can get started with QlikView.
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
How can I do for both 1and 2 patients?
Please reply ASAP
Index(GetFieldSelections([Patient Name]),'1') = 0 and Index(GetFieldSelections([Patient Name]),'2')=0
Let me know
View solution in original post
Use if(GetSelectedCount([Patient Name]) > 2, 1, 0) in your conditional show expression.
Actually Patient Names are text(A,B)
GetSelectedCount should still work I think.
Thanks Alessandro. Its working.
You can use match function
match( M, 'Jan','Feb','Mar')
returns 2 if M = Feb
returns 0 if M = Apr or jan
Could you please mark my answer
Really thank you ...