Data Island with Time?

[#1]

Hi

I have a table with multiple time fields, and I want to be able to work with these multiple fields separately. So therefore I created a time master as a data island.

In my data table I have fields like

Time1

Time2

Time3

The time master is created as follows:

Temp_TimeMaster:

LOAD

     TIME(RowNo()/1440, 'hh:mm') AS Temp_TimeMaster

AUTOGENERATE 24 * 60;

TimeMaster:

LOAD

     Temp_TimeMaster AS TimeMaster

   , Hour(Temp_TimeMaster) AS Hour

   , Minute(Temp_TimeMaster) AS Minute

RESIDENT Temp_TimeMaster

ORDER BY Temp_TimeMaster ASC;

DROP TABLE Temp_TimeMaster;

Now when I try to link the data island to the data table, I get some strange results. Some records are properly linked, some are not. When I compare the decimal values, they actually should match. I compared them up to 10 digits. I use the following expression in the dimension to link the two tables:

=If(Time1 = TimeMaster, Hour, 0)

What am I doing wrong?

Thanks for your help.

[jagan]

Hi,

Can you attach the sample file with some data?

Regards,

Jagan.

[#3 · Accepted solution]

Hi Jagan

Thanks for your prompt reply. It double checked the number format once again in the data table. The times there were stored including seconds, so the values did not match.

[jagan]

Hi,

If you are done with this then close the thread.

Regards,

Jagan.

[MarcoWedel]

search community for master calendar threads like

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar

hope this helps

regards

Marco