topic Combination of duplicated data in QlikView

Combination of duplicated data

Wed, 26 Jun 2013 08:56:13 GMT

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 -> A	2
A -> B	3
A -> C	7
B -> A	6
B -> B	4
B -> C	6
C -> A	3
C -> B	2
C -> C	6

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_operator	Cost
A <-> A	3
A <-> B	9
A <-> C	10
B <-> B	4
B <-> C	8
C <-> C	6

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

Re: Combination of duplicated data

Gysbert_Wassenaar — Wed, 26 Jun 2013 09:12:00 GMT

See attached example.

Re: Combination of duplicated data

Wed, 26 Jun 2013 10:35:16 GMT

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!