topic Re: FACT & dimension in QlikView

FACT & dimension

Mon, 28 Jul 2014 15:10:26 GMT

i have a fact table and dimension table .

how to combine it?

Re: FACT & dimension

MK_QSL — Mon, 28 Jul 2014 15:12:02 GMT

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

Name

Country etc etc.

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

Re: FACT & dimension

Mon, 28 Jul 2014 15:19:24 GMT

Hi, manish

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

its join or concateneate

Re: FACT & dimension

Mon, 28 Jul 2014 15:19:42 GMT

Hi, manish

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

its join or concateneate

Re: FACT & dimension

MK_QSL — Mon, 28 Jul 2014 15:21:29 GMT

For my example

Sales:

Load

CustomerID,

SalesDate,

SalesQty,

SalesAmout

From TableName....

Left Join (Sales)

Load

ID as CustomerID,

Name,

Country

From TableName ....

Re: FACT & dimension

Mon, 28 Jul 2014 15:24:10 GMT

if we have no common fields then?

Re: FACT & dimension

MK_QSL — Mon, 28 Jul 2014 15:30:29 GMT

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

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

Re: FACT & dimension

Mon, 28 Jul 2014 15:34:01 GMT

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

Re: FACT & dimension

Mon, 28 Jul 2014 15:51:44 GMT

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

Re: FACT & dimension

Mon, 28 Jul 2014 15:52:13 GMT

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