topic margin flagging in QlikView https://community.qlik.com/t5/QlikView/margin-flagging/m-p/1285497#M862566 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>Can some one help me with this formula:</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="216" style="width: 631px; height: 216px;" width="631"><TBODY><TR><TD class="xl65" height="17" width="98">ITEM_NO</TD><TD class="xl65" style="border-left: none;" width="98">Sales</TD><TD class="xl65" style="border-left: none;" width="98">Margin</TD><TD class="xl65" style="border-left: none;" width="164">if((column(3) &gt; 0),'Y','N')</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">ORI</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$1,067,241.25</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$417,707.08</TD><TD class="xl66" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">ZZ</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$393,263.33</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$393,263.33</TD><TD class="xl66" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">TSF</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$946,720.60</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$343,977.14</TD><TD class="xl66" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">GLU</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$1,211,490.97</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$337,970.18</TD><TD class="xl66" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">GLU</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$1,029,243.72</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$281,447.37</TD><TD class="xl66" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">TER</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$37,228.43</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">($18,822.36)</TD><TD class="xl66" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">INB</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$4,921.72</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">($18,998.05)</TD><TD class="xl66" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">OSE</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$40,847.47</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">($21,705.15)</TD><TD class="xl66" style="border-top: none; border-left: none;">Y</TD></TR></TBODY></TABLE><P></P><P>I am trying to do:</P><P></P><P>if margin is negative then Y else if N.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT jadams123 2020-11-25T16:16:04Z margin flagging https://community.qlik.com/t5/QlikView/margin-flagging/m-p/1285497#M862566 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>Can some one help me with this formula:</P><P></P><P>&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" height="216" style="width: 631px; height: 216px;" width="631"><TBODY><TR><TD class="xl65" height="17" width="98">ITEM_NO</TD><TD class="xl65" style="border-left: none;" width="98">Sales</TD><TD class="xl65" style="border-left: none;" width="98">Margin</TD><TD class="xl65" style="border-left: none;" width="164">if((column(3) &gt; 0),'Y','N')</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">ORI</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$1,067,241.25</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$417,707.08</TD><TD class="xl66" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">ZZ</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$393,263.33</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$393,263.33</TD><TD class="xl66" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">TSF</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$946,720.60</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$343,977.14</TD><TD class="xl66" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">GLU</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$1,211,490.97</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$337,970.18</TD><TD class="xl66" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">GLU</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$1,029,243.72</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$281,447.37</TD><TD class="xl66" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">TER</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$37,228.43</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">($18,822.36)</TD><TD class="xl66" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">INB</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$4,921.72</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">($18,998.05)</TD><TD class="xl66" style="border-top: none; border-left: none;">Y</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">OSE</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">$40,847.47</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">($21,705.15)</TD><TD class="xl66" style="border-top: none; border-left: none;">Y</TD></TR></TBODY></TABLE><P></P><P>I am trying to do:</P><P></P><P>if margin is negative then Y else if N.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/margin-flagging/m-p/1285497#M862566 jadams123 2020-11-25T16:16:04Z Re: margin flagging https://community.qlik.com/t5/QlikView/margin-flagging/m-p/1285498#M862567 <HTML><HEAD></HEAD><BODY><P>I am guessing that ITEM_NO is a dimension here? May be use Column(2) instead of Column(3)</P><P></P><P><STRONG>If(Column(<SPAN style="color: #ff0000; font-size: 12pt;">2</SPAN>) &gt; 0, 'Y', 'N')</STRONG></P></BODY></HTML> Fri, 06 Jan 2017 15:09:08 GMT https://community.qlik.com/t5/QlikView/margin-flagging/m-p/1285498#M862567 sunny_talwar 2017-01-06T15:09:08Z Re: margin flagging https://community.qlik.com/t5/QlikView/margin-flagging/m-p/1285499#M862568 <HTML><HEAD></HEAD><BODY><P>to avoid confusion maybe</P><P></P><P>if([Margin]&gt;0,'Y','N')</P></BODY></HTML> Fri, 06 Jan 2017 15:11:48 GMT https://community.qlik.com/t5/QlikView/margin-flagging/m-p/1285499#M862568 rupamjyotidas 2017-01-06T15:11:48Z