Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Lets say my field is KEY, and states are State1 and State2.
KEY : A,B,C,D,E,F
{State 1} KEY: A,B,C,D,E
{State 2} KEY: A,B,C,F
Based on the selections done on state 1 and state 2 I need to count the different values on the field KEY between these 2 states in a single expression. In the given example the result should be 3 since D,E and F values are unique to the states. I wasn't able find a way to achieve this. Is it possible?
You could try to fetch the symmetric difference (XOR) between the two states using set analysis. It would look something like this:
count({state_1 / state_2} KEY)
Thank you for the reply, but I am not getting what I wanted. Maybe i executed it wrong. I am expecting a result of 10 and getting the result shown below. (left side filter pane and table are on state_1, right side filter pane and table are on state_2)