topic Text Object in QlikView

Text Object

Fri, 31 Oct 2014 16:36:22 GMT

In a text object, I have this expression: ='Test' &Field

So, when I select any register in this field, this is filtered.

How do I show a text when 'Field' is not selected?

Thank's.

Anonymous — Fri, 31 Oct 2014 16:41:15 GMT

Try this:

=if(GetSelectedCount(Field) = 0,'Field Not Selected','Test ' & Field)

its_anandrjs — Fri, 31 Oct 2014 16:51:40 GMT

In any text object write

Load * inline

[ Field

C ];

=if(isnull( GetFieldSelections(A) ),'No Selection', 'Test ' &Field)

Regards

Anand

ashfaq_haseeb — Fri, 31 Oct 2014 17:05:48 GMT

Hi,

Try this

=if(len(Field) = 0,'No Selection','Test ' & Field)

Regards

ASHFAQ

Fri, 31 Oct 2014 18:31:18 GMT

Both ways have worked.

Thank you so much!

ashfaq_haseeb — Fri, 31 Oct 2014 18:33:30 GMT

Welcome