Discussion Board for collaboration related to QlikView App Development.
assuming i'm having historic table of system defects with the following:
Defect ID, Defect Status, Defect Status Date (the first row per Defect is the creation Date, and the following rows per Defect represents the Defect's Status change and Defect's Status change date)
i need to have:
just to clearify,
what i need to calculate is the number of defects which are "close" and the number of defect which are NOT "close" per day
You can use While clause to generate new rows.
Please find my example.
Hope this helps you.