topic Relation issue in Data Model in QlikView

Relation issue in Data Model

nihhalmca — Mon, 06 Jul 2015 08:40:04 GMT

Hi All,

There are two tables, Dim has one key value as ProductID. It has values in row wise(1,2,3,4). Fact has one key value as ProductID.

It has values in Column wise unlike Dim_ProductID. So i need to convert Dim_ProductID values into column wise to give relation between Fact_ProductID and Dim_ProductID.

Dim_ProductID Dim_ProductID

1,2,3,4 1

Please find the attachment for better understanding.

Thanks,

Nihhal.

Re: Data Model

jonathandienst — Mon, 06 Jul 2015 08:44:55 GMT

... and do precisely what with it?

Qlik Community Tip: Posting Successful Discussion Threads‌

QlikCommunity Tip: How to get answers to your post?

Re: Data Model

linusblomberg — Mon, 06 Jul 2015 08:59:30 GMT

You need to "transpose" Dim. In qlikview you do that with a crosstable load

Re: Data Model

linusblomberg — Mon, 06 Jul 2015 09:02:47 GMT

Or wait, are all the dimension in the same field? then you need to separate them first

Re: Relation issue in Data Model

florentina_doga — Mon, 06 Jul 2015 12:00:11 GMT

hope this help.