Concatenation in UI part

[vipingarg23]

Hi team,

I am using straight chart. I need to merge two fields into one as an attachment.

I am using below but it is not working:

TYPE&''&CODE

Can anyone help me out there?

[effinty2112]

Hi Vipin,

=Type & Code

works. Remember QV is case sensitive.

Regards

Andrew

[vipingarg23]

It is not working as well. It is giving me wrong result as previous.

[sunny_talwar]

Can you share an image to show the issue?

[vipingarg23]

Please find the attached file.

It is showing right data for value south and west but not for EAST as I have multiple value for the EAST.

[effinty2112]

Hi Vipin,

A	B	C	A & B & C
EAST	DT	001	EASTDT001
EAST	DT	002	EASTDT002
SOUTH	CT	007	SOUTHCT007
WEST	BT	005	WESTBT005

?

[vipingarg23]

But I don't want to merge column A

[effinty2112]

A	B	C	B & C
EAST	DT	001	DT001
EAST	DT	002	DT002
SOUTH	CT	007	CT007
WEST	BT	005	BT005

[Anil_Babu_Samineni · Accepted solution]

This?

[vipingarg23]

It worked now.  I am creating adhoc report So those field weer not my dimensions. I add those fields in my dimension and hide them.

Please let me know if any other efficient way that I should use.