Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
RobertPatrician
Contributor II
Contributor II

Manually set key fields?

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 belowCapture.PNG

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.

Labels (1)
1 Reply
jochem_zw
Partner
Partner

No this is not possible