Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Field value in Text object

Hi Experts,

Can we have a fields value on the basis of if condition in Text Object's text

Thanks in advance

10 Replies

Like this.?

=If(GetSelectedCount(Field_Name)>0,Concat(Distinct Field_Name,', '))

MVP
MVP

Yeah, you can have, but can you explain what is your need?

Not sure I understand your question. Field value? May be like this:

=If(Condition, Concat(DISTINCT XYZ), 'Condition Not Met')

Contributor II
Contributor II

my script is like:

tblTest:

Load X,Y,Z;

Select * from testTable;

and what I want is in Text Object's Text

    =If(X=Y,Z)

Text object should display Z's value

This is for a particular selection you mean?

Contributor II
Contributor II

Actually I have only 1 match (X=Y) in entire table

So no need for selection

Specialist II
Specialist II

That's exactly the syntax you'd use.

Would you be able to share a sample with the expected output to help you better?

Contributor II
Contributor II

Hi Sunny and James,

Have droped the idea of using it on chart

But anyway Thanks a lot for replying