topic duplicate (one time or multiple times) row (with CONCATENATE) in QlikView

duplicate (one time or multiple times) row (with CONCATENATE)

Sat, 24 Apr 2010 15:12:57 GMT

Hello Users,

I have the following questions

I want to load the following data set
Date Time Duration[in h]
1/1/2010 7:00PM 10

In the attached file, the result is
Date FromTime ToTime Duration[in h]
1/1/2010 7:00PM 11.59PM 5
1/2/2010 12:00AM 5:00AM 5

But I don't have an idea to get to this
Date Time Duration[in h]
1/1/2010 7:00PM 50

In the attached file, the result is
Date FromTime ToTime Duration[in h]
1/1/2010 7:00PM 11.59PM 5
1/2/2010 12:00AM 11.59PM 24
1/3/2010 12:00AM 9.59PM 21

I can't get it to work, can somebody help me out with this?

Thanks in advance,

Oliver

duplicate (one time or multiple times) row (with CONCATENATE)

sathishkumar_go — Sat, 24 Apr 2010 19:15:50 GMT

Hi Oliver,

In attached file Date is 4/8/2010 and todate also 4/8/2010

what do u want? do u want to calculate 1/1/2010 to 4/8/2010?

-Sathish

duplicate (one time or multiple times) row (with CONCATENATE)

Sat, 24 Apr 2010 23:46:24 GMT

Hi Sathish,

sorry, I used a different file I played with. Attached the right one including the XLS file. You will see, that one row is missing. I have no idea how to implement that.

Thanks for your help,

Oliver

duplicate (one time or multiple times) row (with CONCATENATE)

pover — Sun, 25 Apr 2010 06:39:52 GMT

Oliver,

Here's a solution using intervalmatch and a straight table. It might need a little refining, but it gives you the table you are looking for.

Regards.

duplicate (one time or multiple times) row (with CONCATENATE)

Sun, 25 Apr 2010 13:01:31 GMT

Karl,

thanks for your idea. But it doesn't work, I need the data in the datafile, without modifications in the chart/interface area.

I need to add basically rows.

Any ideas?

Thanks, Oliver