Calculating created,open and closed request.

Mon, 13 Jun 2016 09:36:16 GMT

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.

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

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

topic Calculating created,open and closed request. in QlikView