Data Visualization
Dear QlikView Team,
I want ur help
i want those emp are 'ac' active for year 2012. and also have promotion 'f' for the following yrs 2010,2011,2012
| Emp | Name | FinFlag | Promotion | Active |
| 1 | a | 2008 | f | ac |
| 1 | a | 2009 | f | ac |
| 1 | a | 2010 | f | na |
| 1 | a | 2011 | f | ac |
| 1 | a | 2012 | f | ac |
| 2 | b | 2008 | f | ac |
| 2 | b | 2009 | t | ac |
| 2 | b | 2010 | t | ac |
| 2 | b | 2011 | f | ac |
| 2 | b | 2012 | f | ac |
| 3 | c | 2008 | f | ac |
| 3 | c | 2009 | t | ac |
| 3 | c | 2010 | f | ac |
| 3 | c | 2011 | f | ac |
| 3 | c | 2012 | f | ac |
| 4 | d | 2008 | f | ac |
| 4 | d | 2009 | f | ac |
| 4 | d | 2010 | f | ac |
| 4 | d | 2011 | f | ac |
| 4 | d | 2012 | f | ac |
| 5 | e | 2008 | t | na |
| 5 | e | 2009 | t | na |
| 5 | e | 2010 | t | ac |
| 5 | e | 2011 | f | ac |
| 5 | e | 2012 | f | ac |
| 6 | f | 2008 | ac | |
| 6 | f | 2009 | ac | |
| 6 | f | 2010 | f | ac |
| 6 | f | 2011 | f | ac |
| 6 | f | 2012 | f | ac |
