Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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

Re: Text Object

Hi,

Try this

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

Regards

ASHFAQ

View solution in original post

5 Replies
Highlighted
gabriel_kirst
Contributor III

Re: Text Object

Try this:

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

Re: Text Object

In any text object write

Load * inline

[ Field

A

B

C ];

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

Regards

Anand

Re: Text Object

Hi,

Try this

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

Regards

ASHFAQ

View solution in original post

Not applicable

Re: Text Object

Both ways have worked.

Thank you  so much!

Re: Text Object

Welcome