Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)