Data Visualization

[#1]

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

[#2]

Hello,

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

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

Regards,

Daniele

[#3]

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

[#4]

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