Discussion Board for collaboration on QlikView Scripting.
I created this script but it doesn't result in a link table but it results in a synthetic key.
I don't understand why.
The content of the fields are exactly the same.
Thanks for you help.
year(AddMonths(OrderDate, $(vFiscalOffset))) as BudgetYear,
ceil(month(AddMonths(OrderDate, $(vFiscalOffset)))/3) as BudgetQuarter,
if(EmployeeBusinessEntityID = 'Website', -1, num#(EmployeeBusinessEntityID)) as Budgetholder
Go to Solution.
qualify * ;
You have to link it with Budgetholder so unqualify Budgetholder and reset of tables qualify
This resulted in 2 synthetic keys.
Despite that, thanks for the help