topic Re: Field value in Text object in QlikView

Field value in Text object

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

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

Thanks in advance

Re: Field value in Text object

tamilarasu — Thu, 02 Jun 2016 09:18:47 GMT

Like this.?

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

Re: Field value in Text object

Kushal_Chawda — Thu, 02 Jun 2016 09:21:58 GMT

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

Re: Field value in Text object

sunny_talwar — Thu, 02 Jun 2016 09:34:00 GMT

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

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

Re: Field value in Text object

Anonymous — Thu, 02 Jun 2016 09:43:06 GMT

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

sunny_talwar — Thu, 02 Jun 2016 10:12:21 GMT

This is for a particular selection you mean?

Re: Field value in Text object

Anonymous — Thu, 02 Jun 2016 10:14:40 GMT

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

So no need for selection

Re: Field value in Text object

ThornOfCrowns — Thu, 02 Jun 2016 10:18:04 GMT

That's exactly the syntax you'd use.

Re: Field value in Text object

sunny_talwar — Fri, 03 Jun 2016 01:56:39 GMT

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

Re: Field value in Text object

Anonymous — Fri, 03 Jun 2016 12:50:59 GMT

Hi Sunny and James,

Have droped the idea of using it on chart

But anyway Thanks a lot for replying

Re: Field value in Text object

sunny_talwar — Fri, 03 Jun 2016 12:58:06 GMT

Great, I would suggest closing this thread down by marking 'Assumed Answer' and any helpful responses, if any.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny