Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
vipingarg23
Creator
Creator

Concatenation in UI part

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?

1 Solution

Accepted Solutions
Anil_Babu_Samineni

This?

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

10 Replies
effinty2112
Master
Master

Hi Vipin,

=Type & Code

works. Remember QV is case sensitive.

Regards

Andrew

vipingarg23
Creator
Creator
Author

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
Creator
Creator
Author

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
Master
Master

Hi Vipin,

A B C A & B & C
EASTDT001EASTDT001
EASTDT002EASTDT002
SOUTHCT007SOUTHCT007
WESTBT005WESTBT005

?

vipingarg23
Creator
Creator
Author

But I don't want to merge column A

effinty2112
Master
Master

A B C B & C
EASTDT001DT001
EASTDT002DT002
SOUTHCT007CT007
WESTBT005BT005
Anil_Babu_Samineni

This?

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vipingarg23
Creator
Creator
Author

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.