topic Highlight Figures in QlikView https://community.qlik.com/t5/QlikView/Highlight-Figures/m-p/661342#M241052 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P></P><TABLE><TBODY><TR><TD></TD><TD>FYear</TD><TD>2012/2013</TD><TD></TD><TD></TD><TD>2013/2014</TD><TD></TD><TD></TD></TR><TR><TD>VEHICLE_TYPE</TD><TD>PAID_RANGE</TD><TD>CLAIM_PAID</TD><TD>CLAIM_NOS</TD><TD>PER_CLAIM_COST</TD><TD>CLAIM_PAID</TD><TD>CLAIM_NOS</TD><TD>PER_CLAIM_COST</TD></TR><TR><TD>CAR</TD><TD>&lt;=10000</TD><TD>93,340,652</TD><TD>13,229</TD><TD>8,056</TD><TD>85,508,450</TD><TD>11,773</TD><TD>7,263</TD></TR><TR><TD>CAR</TD><TD>10,001-25,000</TD><TD>256,757,238</TD><TD>14,879</TD><TD>16,256</TD><TD>227,731,908</TD><TD>13,185</TD><TD>17,272</TD></TR><TR><TD>CAR</TD><TD>25,001-50,000</TD><TD>258,981,314</TD><TD>6,911</TD><TD>36,474</TD><TD>245,631,206</TD><TD>6,530</TD><TD>37,616</TD></TR><TR><TD>CAR</TD><TD>50,001-100,000</TD><TD>288,654,790</TD><TD>3,912</TD><TD>73,787</TD><TD>293,902,813</TD><TD>3,933</TD><TD><SPAN style="color: #ff0000;">74,727</SPAN></TD></TR><TR><TD>CAR</TD><TD>100,001-250,000</TD><TD>316,844,291</TD><TD>1,994</TD><TD>158,899</TD><TD>327,001,175</TD><TD>2,083</TD><TD>156,986</TD></TR><TR><TD>CAR</TD><TD>250,001-500,000</TD><TD>160,630,483</TD><TD>472</TD><TD>340,319</TD><TD>180,980,778</TD><TD>520</TD><TD><SPAN style="color: #ff0000;">348,040</SPAN></TD></TR><TR><TD>CAR</TD><TD>500,001-750,000</TD><TD>48,865,220</TD><TD>83</TD><TD>588,738</TD><TD>54,381,040</TD><TD>91</TD><TD><SPAN style="color: #ff0000;">597,594</SPAN></TD></TR></TBODY></TABLE><P></P><P>I have above pivot Table and I want to make the font color red in the last column if the per claim cost for 2013/14 is higher than the per claim cost for 2012/13 as highlighted in red by me . Pls help me how to to do it</P></BODY></HTML> Mon, 06 Oct 2014 03:10:12 GMT upaliwije 2014-10-06T03:10:12Z Highlight Figures https://community.qlik.com/t5/QlikView/Highlight-Figures/m-p/661342#M241052 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P></P><TABLE><TBODY><TR><TD></TD><TD>FYear</TD><TD>2012/2013</TD><TD></TD><TD></TD><TD>2013/2014</TD><TD></TD><TD></TD></TR><TR><TD>VEHICLE_TYPE</TD><TD>PAID_RANGE</TD><TD>CLAIM_PAID</TD><TD>CLAIM_NOS</TD><TD>PER_CLAIM_COST</TD><TD>CLAIM_PAID</TD><TD>CLAIM_NOS</TD><TD>PER_CLAIM_COST</TD></TR><TR><TD>CAR</TD><TD>&lt;=10000</TD><TD>93,340,652</TD><TD>13,229</TD><TD>8,056</TD><TD>85,508,450</TD><TD>11,773</TD><TD>7,263</TD></TR><TR><TD>CAR</TD><TD>10,001-25,000</TD><TD>256,757,238</TD><TD>14,879</TD><TD>16,256</TD><TD>227,731,908</TD><TD>13,185</TD><TD>17,272</TD></TR><TR><TD>CAR</TD><TD>25,001-50,000</TD><TD>258,981,314</TD><TD>6,911</TD><TD>36,474</TD><TD>245,631,206</TD><TD>6,530</TD><TD>37,616</TD></TR><TR><TD>CAR</TD><TD>50,001-100,000</TD><TD>288,654,790</TD><TD>3,912</TD><TD>73,787</TD><TD>293,902,813</TD><TD>3,933</TD><TD><SPAN style="color: #ff0000;">74,727</SPAN></TD></TR><TR><TD>CAR</TD><TD>100,001-250,000</TD><TD>316,844,291</TD><TD>1,994</TD><TD>158,899</TD><TD>327,001,175</TD><TD>2,083</TD><TD>156,986</TD></TR><TR><TD>CAR</TD><TD>250,001-500,000</TD><TD>160,630,483</TD><TD>472</TD><TD>340,319</TD><TD>180,980,778</TD><TD>520</TD><TD><SPAN style="color: #ff0000;">348,040</SPAN></TD></TR><TR><TD>CAR</TD><TD>500,001-750,000</TD><TD>48,865,220</TD><TD>83</TD><TD>588,738</TD><TD>54,381,040</TD><TD>91</TD><TD><SPAN style="color: #ff0000;">597,594</SPAN></TD></TR></TBODY></TABLE><P></P><P>I have above pivot Table and I want to make the font color red in the last column if the per claim cost for 2013/14 is higher than the per claim cost for 2012/13 as highlighted in red by me . Pls help me how to to do it</P></BODY></HTML> Mon, 06 Oct 2014 03:10:12 GMT https://community.qlik.com/t5/QlikView/Highlight-Figures/m-p/661342#M241052 upaliwije 2014-10-06T03:10:12Z Re: Highlight Figures https://community.qlik.com/t5/QlikView/Highlight-Figures/m-p/661343#M241053 <HTML><HEAD></HEAD><BODY><P>You could use one of the expressions before, first or above...to return the value of pivot cells:</P><P>e.g.:</P><P><IMG __jive_id="68299" alt="" class="jiveImage" src="https://community.qlik.com/legacyfs/online/68299_pastedImage_0.png" style="width: 620px; height: 124px;" /></P><P></P><P>Maybe you can attach your .qvw file to clarify the ideal expression</P></BODY></HTML> Mon, 06 Oct 2014 04:31:00 GMT https://community.qlik.com/t5/QlikView/Highlight-Figures/m-p/661343#M241053 danieloberbilli 2014-10-06T04:31:00Z Re: Highlight Figures https://community.qlik.com/t5/QlikView/Highlight-Figures/m-p/661344#M241054 <HTML><HEAD></HEAD><BODY><P>Hi Upali,</P><P></P><P>In your straight chart, in expression press <IMG src="https://community.qlik.com/legacyfs/online/emoticons/plus.png" /> sign. You will get font color option.Write this condition over there.</P><P></P><P>If((2013/14_Perclaimcost&gt;2012/13_Perclaimcost),rgb(255,0,0))</P><P></P><P>Regards</P><P>KC</P></BODY></HTML> Mon, 06 Oct 2014 05:01:06 GMT https://community.qlik.com/t5/QlikView/Highlight-Figures/m-p/661344#M241054 jyothish8807 2014-10-06T05:01:06Z