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

****************************************************************************
#qlik #qliksense #tips

0:00 Intro
0:28 Synthetic keys
5:10 Circular reference

**********************************************************************
Struggling to get your work done? Check out:

📚 Read on Kindle the simplest way to become ultra-productive:

WHO AM I:
🙋🏻‍♂️ I'm Kaush, a Data Analyst and Data Visualization Developer working for a tech company. I live and work in Sweden. I make videos about technology, productivity, and lifestyle design. Say hi to me on Twitter or instagram 😃

[pareshrahool]

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

[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

[Chris-tjes]

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?

[kishorep]

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.