Discussion Board for collaboration related to QlikView App Development.
I have the below table structure in my database:
But when I tried to load the data as it is into QlikView, it will create loops.
Is there any way I can load the data so that there will be no loops?
Maybe something like this?
Remove the synthetic keys and make the composite key combinations like
Key1&'_'&Key2 as KeyA
Some thing like this
If Data A and Data B and Data C are same then concatenate the tables. If you have sample data then provide might be easy.
Load your like below for avoiding the synthetic keys
Key1&'_'&Key2 as Key,
Try like this using Link table, by using this you can Key1 and Key2 as filters also.
The method of using KEY1 + KEY2 = KEY cannot work as the key1 in each table is actually a date key. Which was linked to a calendar.
Sorry I miss this important information out eariler.
I could do a month(date)+Key2 = key, but then I will not be able to keep the calendar.
In above table structure you can rename fields in Table A,B,C and join these three tables on same key and then final output table join with calendar Table