In MS Access creating links between key fields was easy (just drag one field to the other in the data model viewer), but Qlik insists that all linked key fields have the same name. Is there a way to manually set key links without them having the same name?
For my sample purpose, I have some simple test data as below
This was my solution to the problem of "Make a bar chart of number of invoices sent by day of the week." However each of the middle tables has a duplicated field. "Date" in the middle columns is a renamed "Invoice Sent" or "payment made" field.
My original data had all the invoice data in one table, and splitting it like this into three tables was the only way I saw to get the charts I wanted without calculating the "day of week" data twice into the invoices table.