Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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.

Tags (3)
1 Solution

Accepted Solutions
Not applicable

Re: Data Island with Time?

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
MVP & Luminary
MVP & Luminary

Re: Data Island with Time?

Hi,

Can you attach the sample file with some data?

Regards,

Jagan.

Not applicable

Re: Data Island with Time?

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

MVP & Luminary
MVP & Luminary

Re: Data Island with Time?

Hi,

If you are done with this then close the thread.

Regards,

Jagan.

Re: Data Island with Time?

search community for master calendar threads like

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

hope this helps

regards

Marco