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

Problem with Data from different sources.

Hey everyone, just in advance. thanks so much for helping before. Now i have another Problem.

I now found the matching of data problem to be solved. Now when i want to add two sources i have a problem with the following code;

LOAD

     order_id,

     email,

     shipping_method,

     total as order_amount,

     order_status_id,

     payment_method,

     date_added,

     Date(Date('YYYY-MM-DD'),'DD.MM.YYYY') as date_final,

     Year(Date(Date(Mid(date_added,1,10),'YYYY-MM-DD'),'DD.MM.YYYY')) as year,

     Month(Date(Date(Mid(date_added,1,10),'YYYY-MM-DD'),'DD.MM.YYYY')) as month,

     Week(Date(Date(Mid(date_added,1,10),'YYYY-MM-DD'),'DD.MM.YYYY')) as week;

SELECT

order_id,

email,

shipping_method,

total,

order_status_id,

payment_method,

date_added

from live.order;

GoogleAnalyticsConnectorV2_Data:

LOAD

          dim_date as dim_date,

          Date(Date#(dim_date,'YYYYMMDD'),'DD.MM.YYYY')  as date_final,

          Year(Date(Date#(dim_date,'YYYYMMDD'),'DD.MM.YYYY'))  as year,

          Week(Date(Date#(dim_date,'YYYYMMDD'),'DD.MM.YYYY')) as week,

          Month(Date(Date#(dim_date,'YYYYMMDD'),'DD.MM.YYYY')) as month,

          dim_medium as medium,

          dim_keyword as keyword,

          dim_source as source,

          metric_visits as visits,

          dim_landingPagePath as landingpage,

          metric_visitors as unique_visitor

FROM

[http://localhost:5555/QVSource/GoogleAnalyticsConnectorV2/?table=Data&appID=&feed=https%3a%2f%2fwww....]

(html, utf8, embedded labels, table is @1);

What happens now in german called "Zirkelbezüge" appear, rougly translated with " circle relations". How can help?

Best

Christoph

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Christoph,

you'll need to decide how you want to interact with your data, how you want to filter your data.

For example, do you want to select a date and force QV to limit the original fields dim_date as well as date_added to that selected date, or are these dates semantically different and you may want to select different dates in these fields.

There are a lot of threads here in the forum (and in the technical blog) covering the concept of a so called master calendar, and how to link a master calendar to several date fields (using a link table) or how to build separate master calendar tables per date field.

For example, please check:

http://community.qlik.com/message/273830#273830

View solution in original post

3 Replies
swuehl
MVP
MVP

Christoph,

I assume you are having at least one more table ("Zirkelbezüge" needs at least 3 tables in your data model).

Without knowing your complete "Zirkelbezug", it's hard to suggest something.

There is a whole chapter in the reference manual, search for "Zirkelbezüge vermeiden".

A solution to your problem probably involves renaming some fields or re-modelling your data model (e.g. using 1 single fact table instead of multiple, using common date fields).

Not applicable
Author

Hey,

indeed i have three different tables with data formats which seem to cause the Zirkelbezüge.

The problem is:

1. one order table which provides all relevant data to the order. -> matching through date

2. one table which delivers traffic data from google -> matching through date

3. one table which contains costs for adwords -> matching throug date

When i rename the date fields from google, everything works fine. otherwise its screwing up my systems. With the datefields its actually working when i just use two sources from the one database, its only google that is messing with the data.

swuehl
MVP
MVP

Christoph,

you'll need to decide how you want to interact with your data, how you want to filter your data.

For example, do you want to select a date and force QV to limit the original fields dim_date as well as date_added to that selected date, or are these dates semantically different and you may want to select different dates in these fields.

There are a lot of threads here in the forum (and in the technical blog) covering the concept of a so called master calendar, and how to link a master calendar to several date fields (using a link table) or how to build separate master calendar tables per date field.

For example, please check:

http://community.qlik.com/message/273830#273830