Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display text in text object

Hi,

I am creating a report that shows emp details.

I am using one list box for emp name and text object to display emp address for the corresponding emp.

but the address is not displayed in the text object. should i use any macro? if yes plz help me wit macro.

Thanks in advance.

6 Replies
Anonymous
Not applicable
Author

Hi,

Based on the description there could be a number of reasons. Do you have a small example document to attach? I'm sure that would get you a quick resolution from the board members.

llauses243
Creator III
Creator III

Put in Expression of Text Object ...

=

if(getselectedcount ( Emp, true( ) ) = 1, Address)





Not applicable
Author

Hi,

Thanks for the replies.

Since I am newbie to qlikview, kindly reply me where should i specify the above expression briefly.

Not applicable
Author

Hi,

I found out.

I got it.

Thanks.

Not applicable
Author

My address is displayed in text object.

I want city name, state and postal code to be displayed in the same text object.

wat should i add to the existing expression?

Not applicable
Author

Hi,

You can concat the other data items into the existing expression as follows,

=



if(getselectedcount ( Emp, true( ) ) = 1, Address&' ,'&City&', '&Postal)