https://community.qlik.com/t5/App-Development/Find-the-difference-or-common-values-between-several-columns/m-p/2435870#M97009 <P>Hi,</P> <P>I have a pivot table like this:</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Cat 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Cat 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Cat 3</P> <P>Type&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> <P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Yes, <STRONG>All</STRONG>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Yes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Yes</P> <P>B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;M</P> <P>I would like to have another column in any place that will give me 0 when the Values in Categories are different from each other and 1 if same (so 0 for A and 1 for B).&nbsp;</P> <P>And also, I need to show somehow the values that are not common (here: All) by marking it in some colour, or maybe listing in another table if not possible in the pivot. (I have the values as separate ones, they are just concatenated in pivot because it doesn't want to show not concatenated values if more than 1).</P> <P>Thanks for any hint.</P> Fri, 29 Mar 2024 11:55:50 GMT justalkak 2024-03-29T11:55:50Z https://community.qlik.com/t5/App-Development/Find-the-difference-or-common-values-between-several-columns/m-p/2435870#M97009 <P>Hi,</P> <P>I have a pivot table like this:</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Cat 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Cat 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Cat 3</P> <P>Type&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> <P>A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Yes, <STRONG>All</STRONG>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Yes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Yes</P> <P>B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; M&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;M</P> <P>I would like to have another column in any place that will give me 0 when the Values in Categories are different from each other and 1 if same (so 0 for A and 1 for B).&nbsp;</P> <P>And also, I need to show somehow the values that are not common (here: All) by marking it in some colour, or maybe listing in another table if not possible in the pivot. (I have the values as separate ones, they are just concatenated in pivot because it doesn't want to show not concatenated values if more than 1).</P> <P>Thanks for any hint.</P> Fri, 29 Mar 2024 11:55:50 GMT https://community.qlik.com/t5/App-Development/Find-the-difference-or-common-values-between-several-columns/m-p/2435870#M97009 justalkak 2024-03-29T11:55:50Z