Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
xyz1
Contributor III

?

.

1 Solution

Accepted Solutions
prma7799
Honored Contributor III

Re: Common Field Synthetic Key

13 Replies
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.

xyz1
Contributor III

?

.

xyz1
Contributor III

?

.

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

xyz1
Contributor III

?

.

prma7799
Honored Contributor III

Re: Common Field Synthetic Key

Can you please tell me in allocation tab what you have to do.

I mean which criteria basis you need join the tables

prma7799
Honored Contributor III

Re: Common Field Synthetic Key