Discussion Board for collaboration related to QlikView App Development.
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.
Please find the attachment for better understanding.
... and do precisely what with it?
Qlik Community Tip: Posting Successful Discussion Threads
QlikCommunity Tip: How to get answers to your post?
You need to "transpose" Dim. In qlikview you do that with a crosstable load
Or wait, are all the dimension in the same field? then you need to separate them first
hope this help.