Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

shayraber
Contributor

convert distinct data point to a continues data

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:

IDStatusDate
123Open13/1/2015
123fix dev16/1/2015
123fix test20/1/2015
123close21/1/2015

i need to have:

IDStatusDate
123Open13/1/2015
123Open14/1/2015
123Open15/1/2015
123fix dev16/1/2015
123fix dev17/1/2015
123fix dev18/1/2015
123fix dev19/1/2015
123fix test20/1/2015
123close21/1/2015
123close22/1/2015
123close23/1/2015
2 Replies
shayraber
Contributor

Re: convert distinct data point to a continues data

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

Partner
Partner

Re: convert distinct data point to a continues data

Hi,

You can use While clause to generate new rows.

Please find my example.

Hope this helps you.

Regards,

Andrei