Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Re: Logic Problem
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 |
Hello,
can you be more specific please? Do you need a script?
Is the table your source data? What is your goal?
Regards,
Daniele
The above table is my data.
I want that employee who has promotion ='f ' for year(2010,2011,2012) and that employee should also be active 'ac' in 2012 year
Hi
=if(Active='ac' and FinFlag=2012
or
Promotion='f' andFinFlag=2011
or
Promotion='f' andFinFlag=2012
or
Promotion='f' andFinFlag=2013
,Emp,Null())
use this expression in ur calculated dimension