Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

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

Re: Logic Problem
    

Emp Name FinFlagPromotionActive
1a2008fac
1a2009fac
1a2010fna
1a2011fac
1a2012fac
2b2008fac
2b2009tac
2b2010tac
2b2011fac
2b2012fac
3c2008fac
3c2009tac
3c2010fac
3c2011fac
3c2012fac
4d2008fac
4d2009fac
4d2010fac
4d2011fac
4d2012fac
5e2008tna
5e2009tna
5e2010tac
5e2011fac
5e2012fac
6f2008
ac
6f2009
ac
6f2010fac
6f2011fac
6f2012fac

3 Replies
Not applicable

Re: Data Visualization

Hello,

  can you be more specific please? Do you need a script?

Is the table your source data? What is your goal?

Regards,

Daniele

Not applicable

Re: Data Visualization

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

Not applicable

Re: Data Visualization

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