- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Combine multiple data sets without using synthetic keys
Hi, I am new to Qlikview and have some basic questions.
I am trying to import a number of data sets into Qlikview and combine them.
The data sets are as follows.
App1
AuthenticatedUsername, PagesTitles, PagesURLs, Hits, PageViews, ViewTime, TimePeriod, StartDate, EndDate, App1 as Apptyp
App2
AuthenticatedUsername, PagesTitles, PagesURLs, Hits, PageViews, ViewTime, TimePeriod, StartDate, EndDate, App2 as Apptyp
App3
AuthenticatedUsername, PagesTitles, PagesURLs, Hits, PageViews, ViewTime, TimePeriod, StartDate, EndDate, App3 as Apptyp
All Apps
Apptyp, AuthenticatedUsername, Hits, PageViews, Visits, TimePeriod, StartDate, EndDate;
Enrichment Table
ReportingRegion, ReportingBusinessSector, ReportingFullName, AuthenticatedUsername
I would like the end result to be as follows..
The ability to filter on Apptyp and date then drilldown by ReportingRegion, ReportingBusinessSector, ReportingFullName, AuthenticatedUsername. This will then show what pages have been seen in which app depending on the selections made in the filters and drilldown.
I keep getting synthetic keys and have been playing around with concatenating tables, link tables etc however as I am new to Qlikview it would be good if someone could point me in the correct direction. There is a lot more data I want to add so hopefully after I crack this I will be on my way!
Thanks
- « Previous Replies
-
- 1
- 2
- Next Replies »
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
and the some more
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check this Updated file it may fulfill your requirement
- « Previous Replies
-
- 1
- 2
- Next Replies »