Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor II

Synthetic Key


I want to achieve a result as shown below,

I want to select month eg. July

Then, I want to select role eg. “Admin SYS” 

Then, I want to filter-“Assigned” from “type of Assignment” 

Then, I want to know name of employee (Alexandre FAVRE)

and its exact “Allocated/Assigned” Value=2

I am getting correct results but there is one synthetic key

Following is my Script with attached Data and Qlik Sense App:-

3 Replies
Honored Contributor III

Re: Synthetic Key

Please try this

Contributor II

Re: Synthetic Key

Thanks for kind reply,


i can't see

    "Type of Assignment",

    "Cost Per MD",


can you help?


Esteemed Contributor

Re: Synthetic Key


I don't have QlikSense, so I can only theorize:

=> If you have several tables and you want them to link on one field only, but you actually need more fields to be connected, first rename the fields in one table to keep them from linking (or use QUALIFY) and then use APPLYMAP() to get info from one table into the other without linking or joining; Then you can delete the field from the table it came from or just rename it to keep it from linking.


Best regards,