Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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.
New Contributor

Multiple key fields

I'm pretty new to qlikview. I am working on a QLikView project in which I am calcualting the history of inventory for my company. I have run across a daunting problem which I do not know how to solve. I have to be able to manipulate data by the Date, Business Unit (Branch) and Item Number. All of these keys are on my 'fact table'  in my star schema setup, however, I do not know how to effect the dimension tables by all three key fields. For instance, when I connect a table to find the average annual demand I used the common key of item number. This does not work though, as it must also be controlled by business unit also. I can include both fields but then I get a synthetic table and I run out of memory pretty quickly. Is there anyway to connect multiple firelds without a synthetic table?

Thanks for the help.

2 Replies
Not applicable

Re: Multiple key fields


Your question looks similar to the question that is answered in the following thread


Probably it is of use for you and may help.



New Contributor

Re: Multiple key fields

Thanks a ton Gerrit. That helped a ton. I pretty sure thatll solve my problem.

Community Browser