Discussion Board for collaboration on QlikView Scripting.
I have the following questions
I want to load the following data setDate Time Duration[in h]1/1/2010 7:00PM 10
In the attached file, the result isDate FromTime ToTime Duration[in h]1/1/2010 7:00PM 11.59PM 51/2/2010 12:00AM 5:00AM 5
But I don't have an idea to get to thisDate Time Duration[in h]1/1/2010 7:00PM 50
In the attached file, the result isDate FromTime ToTime Duration[in h]1/1/2010 7:00PM 11.59PM 51/2/2010 12:00AM 11.59PM 241/3/2010 12:00AM 9.59PM 21
I can't get it to work, can somebody help me out with this?
Thanks in advance,
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?
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,
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.
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.