topic Symmetric difference (Set operators (/) ) in QlikView

Symmetric difference (Set operators (/) )

Wed, 12 Aug 2015 23:37:23 GMT

Hi,

In set analysis there one type of Set Operator that I haven't used yet, and this is the " Symmetric difference " operator.

I already done some research regarding that operator but I could not find a good example (not even in the reference manual) of how I could use it.

Can you give an example of how I could use it please.

Thanks in advance.

Iuri

Re: Symmetric difference (Set operators (/) )

jafari_ervin — Thu, 13 Aug 2015 07:31:32 GMT

Dear Iuri,

Please read this blog http://aftersync.com/blog/the-magic-of-set-analysis-part-iii

" “/=” – This one is used to define a symmetric difference (XOR), and the resulting record set will contain the values that are present in either one set but not in the other."

I create sample qlikview file for you, Please see the attachment.

In this qlikview file you can see the table with symmetric difference in left side that represented values for Dim 2 that are not started with "D", and the right side staright table show value for the Dim2 that are started with "D".

Re: Symmetric difference (Set operators (/) )

Fri, 14 Aug 2015 15:19:10 GMT

Thanks Jafari,

I could understand now how this feature can be used.