Discussion Board for collaboration related to QlikView App Development.
When I learn QlikView Data Model,I've seen a link between table like this.
General,QlikView create syn keys between table.
How can I generate the link between the green and blue?
What's the difference between this relation and the syn relation?
Thanks in advance.
If you have more than one column name common in both the tables then the Synthetic keys are formed, it is not an issue with Synthetic keys. But it is a good practice to remove those if any. We can solve this by using Concatenate() or Link tables
Try like this using LinkTable
Column2 & Column3 AS Key,
Hope this helps you.
Hi Mr Black,
I have created a tutorial on linking tables via keys that you might find useful: QlikView 11 Developer Tutorial - part 17