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
