Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Honored Contributor II

Re: Display a subset of field values in text object

try something like this :

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

MVP & Luminary
MVP & Luminary

Re: Display a subset of field values in text object

How about:

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

-Rob

Not applicable

Re: Display a subset of field values in text object

That works great actually. Thanks

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

Not applicable

Re: Display a subset of field values in text object

Got it I just add the chr(10).

Thanks a bunch guys!

Community Browser