convert distinct data point to a continues data

shayraber — Wed, 20 May 2015 07:56:30 GMT

hi all,

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)

for example,

a Defect # 1234 created at Jan 13th 2015
its status has changed to "fix dev" on Jan 16th 2015
its status has changed to "fix test" on Jan 20th 2015
its status has changed to "close" on Jan 21st 2015

i have:

ID	Status	Date
123	Open	13/1/2015
123	fix dev	16/1/2015
123	fix test	20/1/2015
123	close	21/1/2015

i need to have:

ID	Status	Date
123	Open	13/1/2015
123	Open	14/1/2015
123	Open	15/1/2015
123	fix dev	16/1/2015
123	fix dev	17/1/2015
123	fix dev	18/1/2015
123	fix dev	19/1/2015
123	fix test	20/1/2015
123	close	21/1/2015
123	close	22/1/2015
123	close	23/1/2015

Re: convert distinct data point to a continues data

shayraber — Wed, 20 May 2015 08:41:29 GMT

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

Re: convert distinct data point to a continues data

crusader_ — Wed, 20 May 2015 09:05:29 GMT

Hi,

You can use While clause to generate new rows.

Please find my example.

Hope this helps you.

Regards,

Andrei

topic Re: convert distinct data point to a continues data in QlikView

convert distinct data point to a continues data

Re: convert distinct data point to a continues data

Re: convert distinct data point to a continues data