topic data from different date reference field in QlikView

data from different date reference field

Fri, 23 Jan 2015 09:03:06 GMT

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.

Re: data from different date reference field

jonathandienst — Fri, 23 Jan 2015 09:18:56 GMT

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

Re: data from different date reference field

Fri, 23 Jan 2015 09:33:01 GMT

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.