topic Re: Showing Text box based on Selection in QlikView

Showing Text box based on Selection

Tue, 10 Jun 2014 13:09:44 GMT

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

Tue, 10 Jun 2014 13:12:19 GMT

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

Tue, 10 Jun 2014 13:13:48 GMT

Actually Patient Names are text(A,B)

alexandros17 — Tue, 10 Jun 2014 13:15:06 GMT

Try this

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

Let me know

Tue, 10 Jun 2014 13:16:18 GMT

GetSelectedCount should still work I think.

Tue, 10 Jun 2014 13:20:39 GMT

Thanks Alessandro. Its working.

sarvjeet — Tue, 10 Jun 2014 13:22:14 GMT

You can use match function

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

returns 2 if M = Feb

returns 0 if M = Apr or jan

alexandros17 — Tue, 10 Jun 2014 13:27:36 GMT

Could you please mark my answer

Really thank you ...