topic Re: Set Analysis Operator: link 2 fields in App Development https://community.qlik.com/t5/App-Development/Set-Analysis-Operator-link-2-fields/m-p/1187982#M22229 <HTML><HEAD></HEAD><BODY><P>This could work, at least the syntax is ok, have you tried it? </P></BODY></HTML> Mon, 19 Sep 2016 19:26:10 GMT swuehl 2016-09-19T19:26:10Z Set Analysis Operator: link 2 fields https://community.qlik.com/t5/App-Development/Set-Analysis-Operator-link-2-fields/m-p/1187981#M22228 <HTML><HEAD></HEAD><BODY><P>Is it possible to use the following in a set analyse ?</P><P>Aim is to neglect the value(s) selected for the [Schedule quater], but instead use the value(s) for the field [close quarter]</P><P></P><P>Sum( {$&lt; [Schedule Quarter]=, [Close Quarter]=[Schedule Quarter] &gt;} [Sales])</P></BODY></HTML> Mon, 19 Sep 2016 19:15:20 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-Operator-link-2-fields/m-p/1187981#M22228 Anonymous 2016-09-19T19:15:20Z Re: Set Analysis Operator: link 2 fields https://community.qlik.com/t5/App-Development/Set-Analysis-Operator-link-2-fields/m-p/1187982#M22229 <HTML><HEAD></HEAD><BODY><P>This could work, at least the syntax is ok, have you tried it? </P></BODY></HTML> Mon, 19 Sep 2016 19:26:10 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-Operator-link-2-fields/m-p/1187982#M22229 swuehl 2016-09-19T19:26:10Z Re: Set Analysis Operator: link 2 fields https://community.qlik.com/t5/App-Development/Set-Analysis-Operator-link-2-fields/m-p/1187983#M22230 <HTML><HEAD></HEAD><BODY><P>Or may be this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Sum({$&lt;[Schedule Quarter]=, [Close Quarter] = p([Schedule Quarter])&gt;} [Sales])</STRONG></SPAN></P></BODY></HTML> Mon, 19 Sep 2016 19:28:00 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-Operator-link-2-fields/m-p/1187983#M22230 sunny_talwar 2016-09-19T19:28:00Z Re: Set Analysis Operator: link 2 fields https://community.qlik.com/t5/App-Development/Set-Analysis-Operator-link-2-fields/m-p/1187984#M22231 <HTML><HEAD></HEAD><BODY><P>I tried and it didn't work</P></BODY></HTML> Thu, 22 Sep 2016 11:37:37 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-Operator-link-2-fields/m-p/1187984#M22231 Anonymous 2016-09-22T11:37:37Z Re: Set Analysis Operator: link 2 fields https://community.qlik.com/t5/App-Development/Set-Analysis-Operator-link-2-fields/m-p/1187985#M22232 <HTML><HEAD></HEAD><BODY><P>This is perfect.</P><P>Thx</P></BODY></HTML> Thu, 22 Sep 2016 11:37:48 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-Operator-link-2-fields/m-p/1187985#M22232 Anonymous 2016-09-22T11:37:48Z