Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
ajitdeshpande
New 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

Re: Field value in Text object

Like this.?

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

Re: Field value in Text object

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

Re: Field value in Text object

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

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

ajitdeshpande
New Contributor II

Re: Field value in Text object

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

Re: Field value in Text object

This is for a particular selection you mean?

ajitdeshpande
New Contributor II

Re: Field value in Text object

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

So no need for selection

thornofcrowns
Valued Contributor II

Re: Field value in Text object

That's exactly the syntax you'd use.

Re: Field value in Text object

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

ajitdeshpande
New Contributor II

Re: Field value in Text object

Hi Sunny and James,

Have droped the idea of using it on chart

But anyway Thanks a lot for replying