topic Re: Logic Problem in QlikView

Logic Problem

Tue, 08 Jan 2013 11:53:20 GMT

Hii to all,

I am sharing a problem and hope that someone will solve it.

I want the count of those employee who are active 'ac' in 2012 and whose promotion flage is 'F' for the last three consecutive year. i am also attaching an application file where i got the result, but there i am also getting f employee whose promotion flag is not 'F' for last three consecutive year.I want to exclude that employee against which promotion flag 'F' is maintained for last three years

Re: Logic Problem

swuehl — Tue, 08 Jan 2013 12:19:11 GMT

Try maybe something like

=count(

Emp = p({<Year={"$(vmaxyear)"},Active={'ac'}>}Emp)

* {"=count({<Promotion = {f}, Year={'>=$(vmaxyear_3)'}>}distinct Year)=3"}

distinct Emp)

Re: Logic Problem

Tue, 08 Jan 2013 13:04:50 GMT

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

Now my data look as above format.I want only those employee who are active in 2012 and Promotion is 'f' for last three year.

Re: Logic Problem

swuehl — Tue, 08 Jan 2013 13:29:21 GMT

You just need to rename field FinFlag to Year and adapt your two variable definitions to the different Year format.

Re: Logic Problem

Wed, 09 Jan 2013 05:11:12 GMT

I don't understand what r u saying. It is my humble request to u to develop the test application based on my given data and requirement.

Re: Logic Problem

swuehl — Wed, 09 Jan 2013 09:34:56 GMT

Data:

LOAD Emp,

Name,

FinFlag as Year,

Promotion,

Active

FROM

[.\empTest2.xlsx]

(ooxml, embedded labels, table is Sheet2);

Variable definitions:

vmaxyear: =max(Year)

vmaxyear_3: =max(Year)-2