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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Combination of duplicated data

I have a problem here. This is the table i got by using the following expression:

object_operator & ' -> ' & stuffs_operator

object_operator & ' -> ' & stuffs_operator

Cost
A -> A2
A -> B3
A -> C7
B -> A6
B -> B4
B -> C6
C -> A3
C -> B2
C -> C6

Is there any way to add "duplicated" data? For example, when there's A -> B and B -> A, the data will turn out to be A <-> B and will not display B -> A in the data anymore. Hence, adding up  A -> B and B -> A together.

object_operator & ' -> ' & stuffs_operatorCost
A <-> A3
A <-> B9
A <-> C10
B <-> B4
B <-> C8
C <-> C6

Can anyone tell me how am i suppose to do this WITHOUT TOUCHING ON SCRIPTS?

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See attached example.


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks for the replied! I tried your codes but it only works for one field. I forgot to mention that actually for object_operator & '  ' & stuffs_operator, object_operator is one field and stuffs_operator is another field. What's another code for two fields instead of one field?

Thanks in advance!