data from different date reference field

[#1]

Hello,

i have the problem, that i want to show a table referenced to month of a date, but the values i calculate based on month are coming from different database values.

The problem now is that i only see the values from one database but not from the other. the selection fields are based on year(timestamp) and the values are calculated for month(timestamp), the other value should be calculated by month(timestamp2) but shown beside the same monthnames.

[jonathandienst]

Hi

The problem relates most likely to the way in which the data from the 2 sources are associated. For example, if they are loaded into two tables associated by timestamp, then nanosecond differences between two otherwise related values would break the association.

I suggest that you post a sample with a subset of data from the two tables(qvw file and sources - xls, text or qvd - if possible). You can scramble the names etc in QV if there are confidentiality concerns.

HTH

Jonathan

[#3]

Hello,

I thought the same, but the link is made by date where no hour, minute or second is there.

The qvw file is quite big, but i post here a screenshot from the link.

the right table "MWOPTR_Rückmeldungen" has the field "Datum" made from date(date#(DJTRDT, 'YYYYMMDD'), 'DD.MM.YYYY') as Datum and the left table is linked and the field "Datum" is made from date(dayname(Zeitpunkt,0,0.25), 'DD.MM.YYYY') as Datum.

Hope this helps for the understanding.

Thanks.