Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text Object

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.

1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III

Hi,

Try this

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

Regards

ASHFAQ

View solution in original post

5 Replies
Anonymous
Not applicable
Author

Try this:

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

its_anandrjs
Champion III
Champion III

In any text object write

Load * inline

[ Field

A

B

C ];

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

Regards

Anand

ashfaq_haseeb
Champion III
Champion III

Hi,

Try this

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

Regards

ASHFAQ

Not applicable
Author

Both ways have worked.

Thank you  so much!

ashfaq_haseeb
Champion III
Champion III

Welcome