topic Link tables in QlikView

Link tables

Thu, 22 Mar 2012 17:57:35 GMT

Hi all ,

Can some one help me how to use link tables as i have two fact tables connecting to same dimmension tables, thus causing cirrcular loops and syntetic keys

Please find attachment

Thanks

Link tables

Jason_Michaelides — Thu, 22 Mar 2012 18:06:18 GMT

Hi,

Concatenate() will often work better than a link table. Something like:

Data:

LOAD

'type1' AS FactType,

From....;

Concatenate (Data)

LOAD

'type2' AS FactType,

From....;

Hope this helps,

Jason

Link tables

Thu, 22 Mar 2012 18:11:36 GMT

Hi i cannot concatinate the fact tables as they deal with different measures one fact table is sales and the other fact table is orders

Link tables

Jason_Michaelides — Thu, 22 Mar 2012 18:14:23 GMT

Which is why you use the FactType field. In your chart expressions you can use set analysis to distinguish between the different fact types - Sales and Orders.