QlikSense tutorial - How to solve Synthetic keys & Circular reference in QlikSense

[@thinkmetrics]

🎓 Get the Qliksense masterclass : www.thinkmetrics.se/masterclass
📕 Get the Formula CheatSheet: www.thinkmetrics.se/cheatsheet

[@chaddwck]

What if I need a filter to work on both tables? Thay share a common column but I dont need to those to be mixed

[@zieben64]

you just stumbled upon why synthetic keys are needed. Synthetic keys allow for "natural joins", no more duplicated key columns, just 1 column which you can then filter on.

[@pareshrahool3048]

Thanks Kaush ,suppose we have synthetic key is the primary or foregn key. How to fix this ? In relationship you need to have same column name in both table to built relationship

[@thinkmetrics]

Hi. You should try and create a unique key by combining the common columns and avoid the synthetic key

[@Chris-tj4es]

Hi Kaush, I see there are 2 fact tables. In case there would have been more dimension tables, would it not be easier to create a link table with each PK of each tables so that the link table takes the central part of the star schema?

[@thinkmetrics]

Hi Chris,
Yes, i that case a Link table may be needed. But In this video i wanted to demonstrate the reason behind Synthetic Key & Circular reference & solve them in an easy way.

[@Chris-tj4es]

@@thinkmetrics Thanks for your reply. Keep up adding great videos.

[@kishorep6806]

hi this kishore the problem is i have 5 schema in database i found the synthesis key even after finding the finding the solution in here while doing the visualization i couldn't retrieve the data or do the visualization

[@Purna_naidu]

What are error -128, -129 & error -1,how to solve these.

[@sunithaathmuri4552]

Thanks Kaush..

[@thinkmetrics]

👍🏻

[@eliezergurevich1068]

excelent! thanks

[@thinkmetrics]

Thanks 🙏

[@loke3969]

Thank kaush

[@thinkmetrics]

👍🏻

[@Purna_naidu]

Hello kaush