topic Display text in text object in QlikView

Display text in text object

Thu, 29 Jul 2010 06:55:14 GMT

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.

Display text in text object

Anonymous — Thu, 29 Jul 2010 07:00:19 GMT

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.

Display text in text object

llauses243 — Thu, 29 Jul 2010 07:49:55 GMT

Put in Expression of Text Object ...

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

Display text in text object

Thu, 29 Jul 2010 08:08:18 GMT

Hi,

Thanks for the replies.

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

Display text in text object

Thu, 29 Jul 2010 08:10:58 GMT

Hi,

I found out.

I got it.

Thanks.

Display text in text object

Thu, 29 Jul 2010 08:31:26 GMT

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?

Display text in text object

Thu, 29 Jul 2010 11:54:15 GMT

Hi,

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

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