topic Calculated Dimension in QlikView https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/835934#M294063 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Have a requirement is that, </P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 314px;"><TBODY><TR><TD class="xl63" height="17" width="98"> </TD><TD class="xl64" style="border-left: none;" width="98">sum(Cost)</TD><TD class="xl64" style="border-left: none;" width="56">sum(Cost)</TD><TD class="xl64" style="border-left: none;" width="31">YOY</TD><TD class="xl64" style="border-left: none;" width="31">YOY</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Period</TD><TD class="xl64" style="border-top: none; border-left: none;">2013</TD><TD class="xl64" style="border-top: none; border-left: none;">2014</TD><TD class="xl64" style="border-top: none; border-left: none;">2013</TD><TD class="xl64" style="border-top: none; border-left: none;">2014</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Team</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2013</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2014</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2013</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2014</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">TeamA</TD><TD class="xl64" style="border-top: none; border-left: none;">10</TD><TD class="xl64" style="border-top: none; border-left: none;">20</TD><TD class="xl66" style="border-top: none; border-left: none;">▼</TD><TD class="xl67" style="border-top: none; border-left: none;">▲</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">TeamB</TD><TD class="xl64" style="border-top: none; border-left: none;">15</TD><TD class="xl64" style="border-top: none; border-left: none;">25</TD><TD class="xl66" style="border-top: none; border-left: none;">▼</TD><TD class="xl67" style="border-top: none; border-left: none;">▲</TD></TR></TBODY></TABLE><P></P><P>As of now which ever value is higher its showing ▲ or ▼.</P><P></P><P>but now it should calculate the difference between period 2014 and 2013 and only if difference &gt; 2 then only the <SPAN style="font-size: 13.3333330154419px;">▲ should display in YOY.</SPAN></P><P></P><P>PFA QVW for reference</P></BODY></HTML> Thu, 09 Jul 2015 04:18:32 GMT vardhancse 2015-07-09T04:18:32Z Calculated Dimension https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/835934#M294063 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Have a requirement is that, </P><P></P><P>&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 314px;"><TBODY><TR><TD class="xl63" height="17" width="98"> </TD><TD class="xl64" style="border-left: none;" width="98">sum(Cost)</TD><TD class="xl64" style="border-left: none;" width="56">sum(Cost)</TD><TD class="xl64" style="border-left: none;" width="31">YOY</TD><TD class="xl64" style="border-left: none;" width="31">YOY</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Period</TD><TD class="xl64" style="border-top: none; border-left: none;">2013</TD><TD class="xl64" style="border-top: none; border-left: none;">2014</TD><TD class="xl64" style="border-top: none; border-left: none;">2013</TD><TD class="xl64" style="border-top: none; border-left: none;">2014</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">Team</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2013</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2014</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2013</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">2014</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">TeamA</TD><TD class="xl64" style="border-top: none; border-left: none;">10</TD><TD class="xl64" style="border-top: none; border-left: none;">20</TD><TD class="xl66" style="border-top: none; border-left: none;">▼</TD><TD class="xl67" style="border-top: none; border-left: none;">▲</TD></TR><TR><TD class="xl64" height="17" style="border-top: none;">TeamB</TD><TD class="xl64" style="border-top: none; border-left: none;">15</TD><TD class="xl64" style="border-top: none; border-left: none;">25</TD><TD class="xl66" style="border-top: none; border-left: none;">▼</TD><TD class="xl67" style="border-top: none; border-left: none;">▲</TD></TR></TBODY></TABLE><P></P><P>As of now which ever value is higher its showing ▲ or ▼.</P><P></P><P>but now it should calculate the difference between period 2014 and 2013 and only if difference &gt; 2 then only the <SPAN style="font-size: 13.3333330154419px;">▲ should display in YOY.</SPAN></P><P></P><P>PFA QVW for reference</P></BODY></HTML> Thu, 09 Jul 2015 04:18:32 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/835934#M294063 vardhancse 2015-07-09T04:18:32Z Re: Calculated Dimension https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/835935#M294064 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/qlik-users/96544">gwassenaar</A>‌ <A href="https://community.qlik.com/qlik-users/23109">jagan</A>‌ Can please help me in getting the same</P></BODY></HTML> Thu, 09 Jul 2015 04:28:39 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/835935#M294064 vardhancse 2015-07-09T04:28:39Z Re: Calculated Dimension https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/835936#M294065 <HTML><HEAD></HEAD><BODY><P>Try expression :</P><P>=if(fabs(Sum(Cost)-After(Sum(Cost)))&gt;2,'▲','▼')</P></BODY></HTML> Thu, 09 Jul 2015 04:42:55 GMT https://community.qlik.com/t5/QlikView/Calculated-Dimension/m-p/835936#M294065 tresB 2015-07-09T04:42:55Z