Hello,
I hope someone will be able to help me; i want to do the following thing:
I want to create a table in Qlikview wich stores data per reload (no refresh) Why? I want to make a chart wich displays how many incidents there where open in for example week 1.
Currently i can only show wich incidents are currently open by doing a simple expression:
if ( IN_closed='0', Count({< IN_number = {"=Today() - Date(IN_DATE_creation_date) <= 7"} >} IN_number))
But i want to have an archive, now when an incident gets closed IN_closed will have the value '1'. so i'm not able to see how many incidents where open in week 1 for example.
So basicly i want a static table (log) in qlikview wich contains the following information.
IN_number | week() | IN_DATE_creation_date
| IN_closed
|
---|
001 | 1 | 01/01/2012 | 0 |
001 | 2 | 01/01/2012 | 0 |
001 | 3 | 01/01/2012 | 0 |
001 | 4 | 01/01/2012 | 0 |
by having this information stored i can make an chart wich displays that there is 1 incident open during the period of 4 weeks.
Thanks.