Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display a subset of field values in text object

Hi all,

Using a text object, I want to list all values for a given field, say field_1, where field_2='x'.

Any ideas?

I thought I could do the following expression would work but no luck:

   =if(field_2='x', field_1)

Regards

Revlin

4 Replies
giakoum
Partner - Master II
Partner - Master II

try something like this :

CONCAT(DISTINCT if(field_2='x', field_1)  ,' - ',if(field_2='x', field_1)) )

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

How about:

concat ({<field_2={x}>} field_1, ',')

-Rob

Not applicable
Author

That works great actually. Thanks

Instead of a '-' how can I add a carriage return in between?

Not applicable
Author

Got it I just add the chr(10).

Thanks a bunch guys!