Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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

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

Tags (2)
4 Replies
sathishkumar_go
Contributor III

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

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

Not applicable

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

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

pover
Honored Contributor

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

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.

Not applicable

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

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

Community Browser