Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Selections

Hi

If I select data in one field how to show the data from another related field in a text object .Please help me write the condition

Regards

Murali Krishna

1 Solution

Accepted Solutions
Sokkorn
Master
Master

Hi Murali,

Did you try this yet

Concat(Field,',') or Concat(DISTINCT Field,',')?

Regards,

Sokkorn

View solution in original post

9 Replies
er_mohit
Master II
Master II

if you select one field

then in text object write

=count(related field)

Not applicable
Author

If(Getselectedcount(field)>0,count(related field))

This expression is working fine and giving me the count.However i want the data of the related field to be displayed.

Please help

Regards

Murali

Not applicable
Author

Hi,

Just write the related field in the text box.

Hope it ll work.

Not applicable
Author

Thanks nazneen

It is working if i select a single data

If I am selecting more than one data it is not working and giving me blank

Regards

Murali

Sokkorn
Master
Master

Hi Murali,

Did you try this yet

Concat(Field,',') or Concat(DISTINCT Field,',')?

Regards,

Sokkorn

Sokkorn
Master
Master

Or

GetFieldSelections(Field) Or

GetFieldSelections(Field,';')

er_mohit
Master II
Master II

Try this

=Concat(DISTINCT Sale,',')

Not applicable
Author

Thanks Mohit

It is working now.

Not applicable
Author

Thanks cheav

It is working now.