Discussion board where members can get started with QlikView.
Can we have a fields value on the basis of if condition in Text Object's text
Thanks in advance
=If(GetSelectedCount(Field_Name)>0,Concat(Distinct Field_Name,', '))
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')
my script is like:
Select * from testTable;
and what I want is in Text Object's Text
Text object should display Z's value
This is for a particular selection you mean?
Actually I have only 1 match (X=Y) in entire table
So no need for selection
That's exactly the syntax you'd use.
Would you be able to share a sample with the expected output to help you better?
Hi Sunny and James,
Have droped the idea of using it on chart
But anyway Thanks a lot for replying