topic Re: Set analysis in App Development https://community.qlik.com/t5/App-Development/Set-analysis/m-p/1573864#M41809 <P>May be this</P><P>Sum({&lt;Currency = e({&lt;Currency = {'AUD'}&gt;})&gt;-&lt;Settlement_Currency = {'AUD'}, InstrumentType = {'Cash'}&gt;} [Market Value])</P> Fri, 26 Apr 2019 13:07:17 GMT sunny_talwar 2019-04-26T13:07:17Z Set analysis https://community.qlik.com/t5/App-Development/Set-analysis/m-p/1573662#M41797 <P>Hi All,</P><P>The below is my data.&nbsp;</P><TABLE><TBODY><TR><TD>Currency</TD><TD>Settlement_Currency</TD><TD>InstrumentType</TD><TD>Market Value</TD><TD>Output</TD></TR><TR><TD><STRONG><FONT color="#008000">AUD</FONT></STRONG></TD><TD>AUD</TD><TD>Fx Forward</TD><TD>1,535,852.50</TD><TD><STRONG>0.00</STRONG></TD></TR><TR><TD><STRONG>AUD</STRONG></TD><TD>AUD</TD><TD>Equity Future</TD><TD>443,468.48</TD><TD><STRONG>0.00</STRONG></TD></TR><TR><TD><STRONG>AUD</STRONG></TD><TD>AUD</TD><TD>Bond Future</TD><TD>280,419.84</TD><TD><STRONG>0.00</STRONG></TD></TR><TR><TD><STRONG>AUD</STRONG></TD><TD>AUD</TD><TD>Interest Rate Future</TD><TD>78,829.03</TD><TD><STRONG>0.00</STRONG></TD></TR><TR><TD>BRL</TD><TD>CHF</TD><TD>Cash</TD><TD>56,774.73</TD><TD>56,774.73</TD></TR><TR><TD>BRL</TD><TD><STRONG>AUD</STRONG></TD><TD><STRONG>Cash</STRONG></TD><TD>54,574.73</TD><TD><STRONG>0.00</STRONG></TD></TR><TR><TD>BRL</TD><TD>BRL</TD><TD>Fx Forward</TD><TD>1,031,776.09</TD><TD>1,031,776.09</TD></TR><TR><TD>CAD</TD><TD>CAD</TD><TD>Fx Forward</TD><TD>1,095,191.66</TD><TD>1,095,191.66</TD></TR><TR><TD>CAD</TD><TD><STRONG>AUD</STRONG></TD><TD><STRONG>Cash</STRONG></TD><TD>579,704.99</TD><TD><STRONG>0.00</STRONG></TD></TR><TR><TD>CAD</TD><TD>CAD</TD><TD>Equity Future</TD><TD>292,857.42</TD><TD>292,857.42</TD></TR><TR><TD>CAD</TD><TD>CAD</TD><TD>Bond Future</TD><TD>-179,203.01</TD><TD>-179,203.01</TD></TR><TR><TD>CAD</TD><TD>CAD</TD><TD>Interest Rate Future</TD><TD>-190,176.83</TD><TD>-190,176.83</TD></TR><TR><TD>CHF</TD><TD>CHF</TD><TD>Fx Forward</TD><TD>1,905,331.94</TD><TD>1,905,331.94</TD></TR><TR><TD>CHF</TD><TD>CHF</TD><TD>Cash</TD><TD>0.00</TD><TD>0.00</TD></TR></TBODY></TABLE><P><SPAN>I need to write a condition in Output column as IF Currency='AUD' then output is "0" OR</SPAN></P><P>Settlement_currency='AUD' and InstrumentType='Cash' then '0' else MarketValue. how to write the above conditions using set analysis?&nbsp;</P> Fri, 26 Apr 2019 08:23:10 GMT https://community.qlik.com/t5/App-Development/Set-analysis/m-p/1573662#M41797 jeevays7 2019-04-26T08:23:10Z Re: Set analysis https://community.qlik.com/t5/App-Development/Set-analysis/m-p/1573864#M41809 <P>May be this</P><P>Sum({&lt;Currency = e({&lt;Currency = {'AUD'}&gt;})&gt;-&lt;Settlement_Currency = {'AUD'}, InstrumentType = {'Cash'}&gt;} [Market Value])</P> Fri, 26 Apr 2019 13:07:17 GMT https://community.qlik.com/t5/App-Development/Set-analysis/m-p/1573864#M41809 sunny_talwar 2019-04-26T13:07:17Z Re: Set analysis https://community.qlik.com/t5/App-Development/Set-analysis/m-p/1575186#M41907 <P>Thank you Sunny.</P> Tue, 30 Apr 2019 15:26:12 GMT https://community.qlik.com/t5/App-Development/Set-analysis/m-p/1575186#M41907 jeevays7 2019-04-30T15:26:12Z