Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

agrimroquette
Contributor II

Common Field Synthetic Key

Hi All,

i have few excel sheets from which i want to make dashboard but i am facing Synthetic key error, can anyone help me to solve these 3 synthetic key?

attached is my Script:

Thanks,

1 Solution

Accepted Solutions
prma7799
Honored Contributor III

Re: Common Field Synthetic Key

PFA...

16 Replies
agrimroquette
Contributor II

Re: Common Field Synthetic Key

vinieme12‌ Do you want data file for reference?

vinieme12
Esteemed Contributor II

Re: Common Field Synthetic Key

Yes , a sample app will be helpful

prma7799
Honored Contributor III

Re: Common Field Synthetic Key

Share a sample qvw file.

agrimroquette
Contributor II

Re: Common Field Synthetic Key

Vineeth,

Attached is my sample data file and Qvf.

Thanks,

agrimroquette
Contributor II

Re: Common Field Synthetic Key

This is the error


Lines fetched: 57

$Syn 1 = Team+Role

$Syn 2 = Employee+Month+Team

$Syn 3 = $Syn 1+$Syn 2 



Not applicable

Re: Common Field Synthetic Key

three synthetic keys is not a big issue, More synthetic keys will not effect your data. even if we take link tables that also same, So you no need to bother about the synthetic keys in your data model.

You can continue with reports without any fear.

prma7799
Honored Contributor III

Re: Common Field Synthetic Key

for this $Syn 1 = Team+Role



left.png

You have to write


left join

agrimroquette
Contributor II

Re: Common Field Synthetic Key

Hi, Vineeth,

i have still 3 synthetic keys error, can you please correct my script? as i dont understand how it can give impact to my results.

Thanks

agrimroquette
Contributor II

Re: Common Field Synthetic Key

i corrected this but still the same error 3 Synthetic keys

Thanks