Data Model - Loop

[#1]

Hello,

We are into publishing business. We post content to the web and users visit our website to view the content.

1) All the content we post is available in content table. The primary key Id is SKUID.

2) Each content is then tagged to an analyst or a market or a retailer. The tagging information is available in SKUTag table.

3) When a user visits the web page when the content is posted, We track the page visit and database in the usagetracker table.

4) To see what content the user viewed, We parse the URL to get the querystring and get the SKUID. We have that information in usagetracker table as SKUID_Viewed. This SKUID_Viewed is same as the SKUID in Content table.

We need to build the following reports,

1) How many pages the user visited this week/month.

2) How many content items are posted this week/month.

3) How many content items not viewed by users.

4) Count of Content produced by various analysts.

5) Top analyst who got max page visits for the article he produced.

Few of the above report are pretty easy to do.

The qlikview interface needs to have a year, quarter, month as parameters so the user will be able to see above reports at various time frames.

The issue we are facing here is that when we rename SKUID_Viewed to SKUID in usage tracker table we end up with a loop.

Just trying to figure out our last step in order to finish this data model with out any syn keys or loops.

Any suggestions appreciated.

Thank you.

[#2]

Keeping the above model intact. Can i get the following result.

1) As an example, we posted 10 articles this week. Only 4 got viewed since they were posted. I am trying to get the remaining 6 by writing some set analysis/expression