topic Straight table cell coloring and total issue- Help me here! in QlikView https://community.qlik.com/t5/QlikView/Straight-table-cell-coloring-and-total-issue-Help-me-here/m-p/363582#M575753 <HTML><HEAD></HEAD><BODY><P>.</P></BODY></HTML> Tue, 24 Apr 2012 09:19:26 GMT subin6600 2012-04-24T09:19:26Z Straight table cell coloring and total issue- Help me here! https://community.qlik.com/t5/QlikView/Straight-table-cell-coloring-and-total-issue-Help-me-here/m-p/363579#M575750 <HTML><HEAD></HEAD><BODY><P>I have a straight table which needs to show the assignment days for a person monthly with data having weekly.</P><P>i.e, the data as shown below. </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 448px;"><TBODY><TR style="height: 15.0pt;"><TD class="xl65" height="20" style="height: 15.0pt; width: 48pt;" width="64">year</TD><TD style="width: 48pt;" width="64">status</TD><TD style="width: 48pt;" width="64">Name</TD><TD class="xl67" style="width: 48pt;" width="64">Week</TD><TD class="xl66" style="width: 48pt;" width="64">mandays</TD><TD style="width: 48pt;" width="64">Month</TD><TD style="width: 48pt;" width="64">Assgn</TD></TR><TR style="height: 15.0pt;"><TD class="xl65" height="20" style="height: 15.0pt;">2011</TD><TD>approved</TD><TD>Subin</TD><TD class="xl67">11</TD><TD class="xl66">2</TD><TD>Mar</TD><TD>social</TD></TR><TR style="height: 15.0pt;"><TD class="xl65" height="20" style="height: 15.0pt;">2011</TD><TD>approved</TD><TD>Subin</TD><TD class="xl67">11</TD><TD class="xl66">3</TD><TD>Mar</TD><TD>science</TD></TR><TR style="height: 15.0pt;"><TD class="xl65" height="20" style="height: 15.0pt;">2011</TD><TD>new</TD><TD>Thomas</TD><TD class="xl67">11</TD><TD class="xl66">4</TD><TD>Mar</TD><TD>science</TD></TR><TR style="height: 15.0pt;"><TD class="xl65" height="20" style="height: 15.0pt;">2011</TD><TD>new</TD><TD>Thomas</TD><TD class="xl67">12</TD><TD class="xl66">1</TD><TD>Mar</TD><TD>social</TD></TR><TR style="height: 15.0pt;"><TD class="xl65" height="20" style="height: 15.0pt;">2011</TD><TD>rejected</TD><TD>george</TD><TD class="xl67">12</TD><TD class="xl66">2</TD><TD>Mar</TD><TD>english</TD></TR><TR style="height: 15.0pt;"><TD class="xl65" height="20" style="height: 15.0pt;">2011</TD><TD>new</TD><TD>george</TD><TD class="xl67">12</TD><TD class="xl66">3</TD><TD>Mar</TD><TD>english</TD></TR><TR style="height: 15.0pt;"><TD class="xl65" height="20" style="height: 15.0pt;">2011</TD><TD>rejected</TD><TD>thomas</TD><TD class="xl67">12</TD><TD class="xl66">4</TD><TD>Mar</TD><TD>english</TD></TR><TR style="height: 15.0pt;"><TD class="xl65" height="20" style="height: 15.0pt;">2011</TD><TD>new</TD><TD>subin</TD><TD class="xl67">13</TD><TD class="xl66">2</TD><TD>Apr</TD><TD>maths</TD></TR><TR style="height: 15.0pt;"><TD class="xl65" height="20" style="height: 15.0pt;">2011</TD><TD>approved</TD><TD>thomas</TD><TD class="xl67">13</TD><TD class="xl66">5</TD><TD>Apr</TD><TD>maths</TD></TR><TR style="height: 15.0pt;"><TD class="xl65" height="20" style="height: 15.0pt;">2011</TD><TD>new</TD><TD>george</TD><TD class="xl67">13</TD><TD class="xl66">3</TD><TD>Apr</TD><TD>maths</TD></TR><TR style="height: 15.0pt;"><TD class="xl65" height="20" style="height: 15.0pt;">2011</TD><TD>rejected</TD><TD>george</TD><TD class="xl67">13</TD><TD class="xl66">3</TD><TD>Apr</TD><TD>english</TD></TR><TR style="height: 15.0pt;"><TD class="xl65" height="20" style="height: 15.0pt;">2011</TD><TD>new</TD><TD>george</TD><TD class="xl67">14</TD><TD class="xl66">2</TD><TD>Apr</TD><TD>english</TD></TR></TBODY></TABLE><P></P><P>PFA Qlikview document where i need to color code based on the status as in here i have New in Red, Approved in Green and rejected in blue.</P><P></P><P><STRONG>Requirement: </STRONG>I want to have the total based on a person for each month as shown in the qv file. And the total value cell should not have any colors.</P><P>Could any one please help me here.</P><P></P><P>Regards,</P><P>Subin Thomas</P></BODY></HTML> Mon, 23 Apr 2012 13:25:31 GMT https://community.qlik.com/t5/QlikView/Straight-table-cell-coloring-and-total-issue-Help-me-here/m-p/363579#M575750 subin6600 2012-04-23T13:25:31Z Re: Straight table cell coloring and total issue- Help me here! https://community.qlik.com/t5/QlikView/Straight-table-cell-coloring-and-total-issue-Help-me-here/m-p/363580#M575751 <HTML><HEAD></HEAD><BODY><P> hi</P><P>check the attch file </P><P></P><P>i use dimensionality() in the background formula</P></BODY></HTML> Mon, 23 Apr 2012 13:34:17 GMT https://community.qlik.com/t5/QlikView/Straight-table-cell-coloring-and-total-issue-Help-me-here/m-p/363580#M575751 lironbaram 2012-04-23T13:34:17Z Straight table cell coloring and total issue- Help me here! https://community.qlik.com/t5/QlikView/Straight-table-cell-coloring-and-total-issue-Help-me-here/m-p/363581#M575752 <HTML><HEAD></HEAD><BODY><P>I got the row to be in the correct format but could i get it in the column as well??</P><P></P><P>Thanks for the immediate reponse Liron.</P></BODY></HTML> Mon, 23 Apr 2012 14:07:49 GMT https://community.qlik.com/t5/QlikView/Straight-table-cell-coloring-and-total-issue-Help-me-here/m-p/363581#M575752 subin6600 2012-04-23T14:07:49Z Straight table cell coloring and total issue- Help me here! https://community.qlik.com/t5/QlikView/Straight-table-cell-coloring-and-total-issue-Help-me-here/m-p/363582#M575753 <HTML><HEAD></HEAD><BODY><P>.</P></BODY></HTML> Tue, 24 Apr 2012 09:19:26 GMT https://community.qlik.com/t5/QlikView/Straight-table-cell-coloring-and-total-issue-Help-me-here/m-p/363582#M575753 subin6600 2012-04-24T09:19:26Z