Discussion Board for collaboration on QlikView Scripting.
Lets say I have a cross table with my customers and their monthly targets :
Then I have my customers and their sales :
I need to link both the Month-Year field and the customer field together, resulting in synthetic keys, is there a way I can get around this as with a bit data set its causing loops.
you will have to use both field (Customer & Month-Year) as key. You will also have to get these 2 tabels at the same level. One way is to make a datefield of Month-Year, like 01/01/2014. Or you can aggregate the sales data on Month-Year level.