I have a straight table which needs to show the assignment days for a person monthly with data having weekly.
i.e, the data as shown below.
| year | status | Name | Week | mandays | Month | Assgn |
| 2011 | approved | Subin | 11 | 2 | Mar | social |
| 2011 | approved | Subin | 11 | 3 | Mar | science |
| 2011 | new | Thomas | 11 | 4 | Mar | science |
| 2011 | new | Thomas | 12 | 1 | Mar | social |
| 2011 | rejected | george | 12 | 2 | Mar | english |
| 2011 | new | george | 12 | 3 | Mar | english |
| 2011 | rejected | thomas | 12 | 4 | Mar | english |
| 2011 | new | subin | 13 | 2 | Apr | maths |
| 2011 | approved | thomas | 13 | 5 | Apr | maths |
| 2011 | new | george | 13 | 3 | Apr | maths |
| 2011 | rejected | george | 13 | 3 | Apr | english |
| 2011 | new | george | 14 | 2 | Apr | english |
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.
Requirement: 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.
Could any one please help me here.
Regards,
Subin Thomas
