Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
Not applicable

FACT & dimension

i have a fact table and dimension table .

how to combine it?

9 Replies
Highlighted
MVP
MVP

Re: FACT & dimension

There should be some common field between them...

Consider that you have fact table ... Sales having below fields

CustomerID

SalesDate

SalesQty

SalesAmout etc etc

and a Dimension Table Customer with below fields..

ID

Name

Country etc etc.

rename the Customer Table's ID field as CustomerID, which will now create an association between Sales and Customer Table..

Highlighted
Not applicable

Re: FACT & dimension

Hi, manish

its good but i want to show the two tables into a single table in datamodel

its join or concateneate

Highlighted
Not applicable

Re: FACT & dimension

Hi, manish

its good but i want to show the two tables into a single table in datamodel

its join or concateneate

Highlighted
MVP
MVP

Re: FACT & dimension

For my example

Sales:

Load

     CustomerID,    

     SalesDate,

     SalesQty,

     SalesAmout

From TableName....

Left Join (Sales)

Load

     ID     as CustomerID,

     Name,

     Country

From TableName ....

Highlighted
Not applicable

Re: FACT & dimension

if we have no common fields then?

Highlighted
MVP
MVP

Re: FACT & dimension

Not possible to link them... ....

Let us know your tables and their fields you are talking about..

Highlighted
Not applicable

Re: FACT & dimension

It all depends on How the tables are related and what is your requirement on the UI to represnt the data

Highlighted
Not applicable

Re: FACT & dimension

It all depends on How the tables are related and what is your requirement on the UI to represnt the data

Highlighted
Not applicable

Re: FACT & dimension

You can do either of one depends on the Tables data attributes.