topic Calculate & Compare Actual/Mean & coloring table value based on results in App Development https://community.qlik.com/t5/App-Development/Calculate-Compare-Actual-Mean-coloring-table-value-based-on/m-p/1457146#M35883 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #545352; font-family: 'QlikView Sans', sans-serif; font-size: 16px;">Qlik Sense: November Release - Desktop Version</SPAN></P><P><SPAN style="color: #545352; font-family: 'QlikView Sans', sans-serif; font-size: 16px;"><BR /></SPAN></P><P><SPAN style="color: #545352; font-family: 'QlikView Sans', sans-serif; font-size: 16px;">I have attached a sample App, Can anyone please fix my challenge i fear that i have been looking at it too long to see the issue. Thank you in advance!<BR /></SPAN></P><P><SPAN style="color: #545352; font-family: 'QlikView Sans', sans-serif; font-size: 16px;"><BR /></SPAN></P><P><SPAN style="color: #545352; font-family: 'QlikView Sans', sans-serif; font-size: 16px;">Problem:</SPAN></P><P style="font-family: 'QlikView Sans', sans-serif; color: #545352; font-size: 16px; text-align: inherit;">1) I'm trying to show the Mean Value by Category Type. I don't think this is correct as coded in the table example included</P><DIV style="text-align: inherit;">2) Across Category Key and Category Type, I want to compare the Actual Value to the Mean Value and color the TEXT Actual Values RED for those results that are greater the Mean. And Green for those that are less than the Mean.<P></P></DIV></BODY></HTML> Sat, 16 Nov 2024 08:54:26 GMT deerhunter 2024-11-16T08:54:26Z Calculate & Compare Actual/Mean & coloring table value based on results https://community.qlik.com/t5/App-Development/Calculate-Compare-Actual-Mean-coloring-table-value-based-on/m-p/1457146#M35883 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #545352; font-family: 'QlikView Sans', sans-serif; font-size: 16px;">Qlik Sense: November Release - Desktop Version</SPAN></P><P><SPAN style="color: #545352; font-family: 'QlikView Sans', sans-serif; font-size: 16px;"><BR /></SPAN></P><P><SPAN style="color: #545352; font-family: 'QlikView Sans', sans-serif; font-size: 16px;">I have attached a sample App, Can anyone please fix my challenge i fear that i have been looking at it too long to see the issue. Thank you in advance!<BR /></SPAN></P><P><SPAN style="color: #545352; font-family: 'QlikView Sans', sans-serif; font-size: 16px;"><BR /></SPAN></P><P><SPAN style="color: #545352; font-family: 'QlikView Sans', sans-serif; font-size: 16px;">Problem:</SPAN></P><P style="font-family: 'QlikView Sans', sans-serif; color: #545352; font-size: 16px; text-align: inherit;">1) I'm trying to show the Mean Value by Category Type. I don't think this is correct as coded in the table example included</P><DIV style="text-align: inherit;">2) Across Category Key and Category Type, I want to compare the Actual Value to the Mean Value and color the TEXT Actual Values RED for those results that are greater the Mean. And Green for those that are less than the Mean.<P></P></DIV></BODY></HTML> Sat, 16 Nov 2024 08:54:26 GMT https://community.qlik.com/t5/App-Development/Calculate-Compare-Actual-Mean-coloring-table-value-based-on/m-p/1457146#M35883 deerhunter 2024-11-16T08:54:26Z Re: Calculate & Compare Actual/Mean & coloring table value based on results https://community.qlik.com/t5/App-Development/Calculate-Compare-Actual-Mean-coloring-table-value-based-on/m-p/1457147#M35884 <HTML><HEAD></HEAD><BODY><P>In the attached I have created a new Sheet called <EM>Test Bill</EM>, is the table at the bottom of that sheet what you are after ?</P></BODY></HTML> Mon, 01 Jan 2018 19:10:03 GMT https://community.qlik.com/t5/App-Development/Calculate-Compare-Actual-Mean-coloring-table-value-based-on/m-p/1457147#M35884 Anonymous 2018-01-01T19:10:03Z