https://community.qlik.com/t5/App-Development/Intersection-and-addition-of-quarter-values/m-p/1844576#M69890 <P>Hi All,</P><P>I am having set of&nbsp; ID fields which common for quarters&nbsp; but not always. Hence I need to calculate the values&nbsp; which is common.&nbsp; My data set look alike</P><P>QTR, ID, Value<BR />Q4,1,10<BR />Q4,2,20<BR />Q4,3,30<BR />Q3,1,11<BR />Q3,2,40<BR />Q3,4,10<BR />Here I need to sum only the IDs of 1,2 since these are the ids common between the Quarters. Hence my output should be like this&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>&nbsp;</TD><TD>Q3</TD><TD>Q4</TD></TR><TR><TD>ID</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>20</TD><TD>40</TD></TR><TR><TD>1</TD><TD>11</TD><TD>10</TD></TR><TR><TD>Total</TD><TD>31</TD><TD>50</TD></TR></TBODY></TABLE><P>Kindly help me</P> Sun, 10 Oct 2021 18:14:44 GMT prakashij_25 2021-10-10T18:14:44Z https://community.qlik.com/t5/App-Development/Intersection-and-addition-of-quarter-values/m-p/1844576#M69890 <P>Hi All,</P><P>I am having set of&nbsp; ID fields which common for quarters&nbsp; but not always. Hence I need to calculate the values&nbsp; which is common.&nbsp; My data set look alike</P><P>QTR, ID, Value<BR />Q4,1,10<BR />Q4,2,20<BR />Q4,3,30<BR />Q3,1,11<BR />Q3,2,40<BR />Q3,4,10<BR />Here I need to sum only the IDs of 1,2 since these are the ids common between the Quarters. Hence my output should be like this&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>&nbsp;</TD><TD>Q3</TD><TD>Q4</TD></TR><TR><TD>ID</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>2</TD><TD>20</TD><TD>40</TD></TR><TR><TD>1</TD><TD>11</TD><TD>10</TD></TR><TR><TD>Total</TD><TD>31</TD><TD>50</TD></TR></TBODY></TABLE><P>Kindly help me</P> Sun, 10 Oct 2021 18:14:44 GMT https://community.qlik.com/t5/App-Development/Intersection-and-addition-of-quarter-values/m-p/1844576#M69890 prakashij_25 2021-10-10T18:14:44Z