Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data Island with Time?

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.

1 Solution

Accepted Solutions
Not applicable
Author

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.

View solution in original post

4 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Can you attach the sample file with some data?

Regards,

Jagan.

Not applicable
Author

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
Luminary Alumni
Luminary Alumni

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