Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Data Model Troubles

Well, I'm in over my head.

I'm part of an integration project and am trying to dashboard without a data warehouse.

Loading various source files into Qlikview, my data model has the appearance of a synthetic main table being fed by various synthetic keys from my source files.

The more files I load, the more my reports stop working. So I know something is wrong here.

If anyone has had this problem, please let me know.

I feel one solution would be to load the files into a virtual fact table in qlikview - if this is possible any script example would be appreciated.

1 Solution

Accepted Solutions
jason_michaelid
Honored Contributor II

Re: Data Model Troubles

Just search here for "Synthetic Keys" and you'll get loads of advice!

4 Replies
Not applicable

Re: Data Model Troubles

For now I'm going to try concatenating most of these into one....

jason_michaelid
Honored Contributor II

Re: Data Model Troubles

Just search here for "Synthetic Keys" and you'll get loads of advice!

Not applicable

Re: Data Model Troubles

Thanks Jason!

jason_michaelid
Honored Contributor II

Re: Data Model Troubles

No problem.  If you have what you need please mark a correct answer to close the thread.

Community Browser