topic Re: Data Island with Time? in QlikView

Data Island with Time?

Fri, 29 Aug 2014 02:25:22 GMT

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.

Re: Data Island with Time?

jagan — Fri, 29 Aug 2014 02:44:18 GMT

Hi,

Can you attach the sample file with some data?

Regards,

Jagan.

Re: Data Island with Time?

Fri, 29 Aug 2014 04:14:41 GMT

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.

Re: Data Island with Time?

jagan — Fri, 29 Aug 2014 04:23:38 GMT

Hi,

If you are done with this then close the thread.

Regards,

Jagan.

Re: Data Island with Time?

MarcoWedel — Fri, 29 Aug 2014 07:13:10 GMT

search community for master calendar threads like

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

hope this helps

regards

Marco