Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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".
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".
Thanks Jafari,
I could understand now how this feature can be used.