Calculating created,open and closed request.

[#1]

Dear All,

I'm quite new to qlikview and need some help with the following;

I'm trying to create a table that contains all request;

               that have been created in a month,

               that are still open in the month

               that have been closed in the month.

Hope this make sense.

The following tabel shows the situations that can occur.

	April	May	June
A		Created	Closed
B	Created	Closed
C	Created		Closed
D		Created - Closed

So to calculate the requests of May the following needs to be done;

#Created	A;D
#Closed	B;D
#Open	C

The requests have a Created field and a Completed field.

How do I create the correct expressions to do this?

I have tried to search the forum to find a solution but did not succeded.

Your help is appreciated.

regards,

Kamho