topic Link table using set analysis in App Development https://community.qlik.com/t5/App-Development/Link-table-using-set-analysis/m-p/1223646#M23816 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I have following model:</P><P><IMG alt="modelo.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/144758_modelo.jpg" style="height: 196px; width: 620px;" /></P><P>$KeyFechaTicket is a key from master calendar and it has a comparative date 1 year before.</P><P>For example: <SPAN style="color: #808080; font-size: 10pt;">15/11/14 vs </SPAN><SPAN style="font-size: 10pt; color: #808080;">16/11/13....03/03/16 vs 20/03/15....</SPAN></P><P></P><P>I want to sum "Cantidad Items" using %KeyFechaComparación = [Fecha Ticket]. I try doing it using the following expression but doesn't work: </P><P><SPAN style="color: #808080;">&nbsp;&nbsp;&nbsp;&nbsp; sum({&lt;%KeyFechaTicket=, [%KeyFechaComparación] = {[Fecha Ticket]} &gt;} [Cantidad Items])</SPAN></P><P></P><P>Anyone can help me?...</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 24 Nov 2016 13:35:26 GMT 2016-11-24T13:35:26Z Link table using set analysis https://community.qlik.com/t5/App-Development/Link-table-using-set-analysis/m-p/1223646#M23816 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I have following model:</P><P><IMG alt="modelo.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/144758_modelo.jpg" style="height: 196px; width: 620px;" /></P><P>$KeyFechaTicket is a key from master calendar and it has a comparative date 1 year before.</P><P>For example: <SPAN style="color: #808080; font-size: 10pt;">15/11/14 vs </SPAN><SPAN style="font-size: 10pt; color: #808080;">16/11/13....03/03/16 vs 20/03/15....</SPAN></P><P></P><P>I want to sum "Cantidad Items" using %KeyFechaComparación = [Fecha Ticket]. I try doing it using the following expression but doesn't work: </P><P><SPAN style="color: #808080;">&nbsp;&nbsp;&nbsp;&nbsp; sum({&lt;%KeyFechaTicket=, [%KeyFechaComparación] = {[Fecha Ticket]} &gt;} [Cantidad Items])</SPAN></P><P></P><P>Anyone can help me?...</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 24 Nov 2016 13:35:26 GMT https://community.qlik.com/t5/App-Development/Link-table-using-set-analysis/m-p/1223646#M23816 2016-11-24T13:35:26Z Re: Link table using set analysis https://community.qlik.com/t5/App-Development/Link-table-using-set-analysis/m-p/1223647#M23817 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample with the expected output to be able to help you out better here.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Fri, 25 Nov 2016 19:15:08 GMT https://community.qlik.com/t5/App-Development/Link-table-using-set-analysis/m-p/1223647#M23817 sunny_talwar 2016-11-25T19:15:08Z