topic Re: (GetFieldSelections([Text Field]) not working in QlikView

(GetFieldSelections([Text Field]) not working

Sun, 11 Aug 2013 08:32:31 GMT

Hi Masters,

I'm using SHOW CONDITIONAL in a Table Box that I only want it to appear when the user has selected a value from a List Box.

It works well with a numeric field, but it does not work with a text field. Any idea how to resolve it?

This works:

=if(GetFieldSelections([Project Number]),1,0)

This DOES NOT work:

=if(GetFieldSelections([Project Name]),1,0)

Thanks in advance for your help!

Re: (GetFieldSelections([Text Field]) not working

Gysbert_Wassenaar — Sun, 11 Aug 2013 08:59:05 GMT

Getfieldselections returns the actual selected values. If you use the return value of getfieldselections as a boolean, i.e. True or False, like you do in your if statement then any number other than 0 is evaluated as True. Text values are evaluated as False.

What you can do instead is use the getselectedcount function: if(GetSelectedCount([Project Name]),1,0).

Actually since the expression for Show Conditional should return True or False you can leave out the if statement and use just GetSelectedCount([Project Name]). If there are selections in Project Name then getselectedcount will be larger than 0, i.e. True. If there are no selections then 0 is returned, i.e. False.

Re: (GetFieldSelections([Text Field]) not working

Sun, 11 Aug 2013 16:48:33 GMT

It worked perfectly! Thanks a tonsssss