Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I want to distribute kilograms on multiple distribution percentages of different dimensions (Categories, Size, ...).
The distribution has multiple tables with different agregations, so I think one way is to have "island" tables and multiply with the related data. But didn't work.
I've attached an excel with some example data.
1 Example: Kilograms
2 Example: % Distribution by Category
3 Example: % Distribution by Size
4 Example: Kilograms Distributed
Thanks!
Hi,
Now the synthetic keys in this might need some thought, but I don't think you need to use a data island;
Am I missing something?
Cheers,
Chris.
Script in case you cant open the attachment;
QlikView associates on all fields with the same name, unless you specifically rename them.
So here factory is included in the association, but for 1116 factory = 1 on Data & 3 on Category by vari and Size tabs.
You can try changing these;
vari:
LOAD
Year,
factory as factory_vari,
And;
size:
LOAD Year,
factory as factory_size,
Which looks to me like it works, but not sure what effect that would have on the rest of your model or the other ways you may wish to apportion.
Cheers,
Chris.