Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
nihhalmca
Specialist II
Specialist II

Relation issue in Data Model

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

                                                   2

                                                   3

                                                   4

Please find the attachment for better understanding.

Thanks,

Nihhal.

4 Replies
jonathandienst

... and do precisely what with it?

Qlik Community Tip: Posting Successful Discussion Threads

QlikCommunity Tip: How to get answers to your post?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
linusblomberg
Creator II
Creator II

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

linusblomberg
Creator II
Creator II

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

florentina_doga
Partner
Partner

hope this help.