topic Varience in QlikView https://community.qlik.com/t5/QlikView/Varience/m-p/729261#M261302 <HTML><HEAD></HEAD><BODY><P>I have calculated Variance (Actual_Budget) in my pivot table which is attache H/w</P><P></P><P>I want to the Variance to appear as follows</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 4.9pt;" width="420"><TBODY><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; background: whitesmoke; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><STRONG style="color: #333333; font-size: 8.0pt; font-family: 'Tahoma','sans-serif';">GROUP_DESCRIPTION</STRONG></P></TD><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-left: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Actual</SPAN></P></TD><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-left: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Budget</SPAN></P></TD><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-left: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">varience</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">SALES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">100,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">150,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">(50,000)</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">COST OF SALES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">40,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">70,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">(30,000)</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">GROSS_PROFIT</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">60,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">80,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">(20,000)</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">STAFF_EXPENSES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">10,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">15,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #92d050;">5,000</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">ADMIN_EXPENSES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">2,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">3,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #92d050;">1,000</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">SELLI_EXPENSES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">4,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">6,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #92d050;">2,000</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">FINAN_EXPENSES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">1,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">1,500</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #92d050;">500</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">TOTAL_EXPENSES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">7,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">10,500</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #92d050;">3,500</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">OTHER INCOME</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">3,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">4,500</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">(1,500)</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">NET_PROFIT</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">50,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">65,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">(15,000)</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>Favorable Variance should be green without brackets. But in my Pivot table it is shown within brackets </P><P>Pls correct my expression to suit my requirement</P></BODY></HTML> Mon, 08 Sep 2014 09:32:31 GMT upaliwije 2014-09-08T09:32:31Z Varience https://community.qlik.com/t5/QlikView/Varience/m-p/729261#M261302 <HTML><HEAD></HEAD><BODY><P>I have calculated Variance (Actual_Budget) in my pivot table which is attache H/w</P><P></P><P>I want to the Variance to appear as follows</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="margin-left: 4.9pt;" width="420"><TBODY><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; background: whitesmoke; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><STRONG style="color: #333333; font-size: 8.0pt; font-family: 'Tahoma','sans-serif';">GROUP_DESCRIPTION</STRONG></P></TD><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-left: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Actual</SPAN></P></TD><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-left: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">Budget</SPAN></P></TD><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-left: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">varience</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">SALES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">100,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">150,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">(50,000)</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">COST OF SALES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">40,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">70,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">(30,000)</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">GROSS_PROFIT</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">60,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">80,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">(20,000)</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">STAFF_EXPENSES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">10,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">15,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #92d050;">5,000</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">ADMIN_EXPENSES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">2,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">3,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #92d050;">1,000</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">SELLI_EXPENSES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">4,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">6,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #92d050;">2,000</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">FINAN_EXPENSES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">1,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">1,500</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #92d050;">500</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">TOTAL_EXPENSES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">7,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">10,500</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #92d050;">3,500</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">OTHER INCOME</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">3,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">4,500</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">(1,500)</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid gainsboro 1.0pt; border-top: none; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="124"><P><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">NET_PROFIT</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">50,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">65,000</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid gainsboro 1.0pt; border-right: solid gainsboro 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="99"><P align="right" style="text-align: right;"><SPAN style="font-size: 8.0pt; font-family: 'Tahoma','sans-serif'; color: #333333;">(15,000)</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>Favorable Variance should be green without brackets. But in my Pivot table it is shown within brackets </P><P>Pls correct my expression to suit my requirement</P></BODY></HTML> Mon, 08 Sep 2014 09:32:31 GMT https://community.qlik.com/t5/QlikView/Varience/m-p/729261#M261302 upaliwije 2014-09-08T09:32:31Z