Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Put in Expression of Text Object ...
=
if(getselectedcount ( Emp, true( ) ) = 1, Address)
Hi,
Thanks for the replies.
Since I am newbie to qlikview, kindly reply me where should i specify the above expression briefly.
Hi,
I found out.
I got it.
Thanks.
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?
Hi,
You can concat the other data items into the existing expression as follows,
=
if(getselectedcount ( Emp, true( ) ) = 1, Address&' ,'&City&', '&Postal)