Discussion Board for collaboration related to QlikView App Development.
Hi,
I've got a model which has got synthetic tables, but this is due to a number of sub ledgers that i need to link to each other:
For each of the above mentioned I have to bring in the year, business unit and responsibility center in order to report accurately.
How do I clear this synthetic table that consists out of the year, business unite and responsibility center?
create key of those field and rename those field.
or
link table will help you.
search on community there are so many threads available to solve it.
Regards,
create key of those field and rename those field.
or
link table will help you.
search on community there are so many threads available to solve it.
Regards,
1) In your load script create these calculated field for both the GeneralLedgerEntries and ItemLedgerEntries tables:
Autonumber(Year &'|'&BU&'|'&[Responsibility Center]&'|'&[Document No],'YBRD') AS %YBRD,
Autonumber(Year &'|'&BU&'|'&[Responsibility Center]&'|'&[Document No],'YBR') AS %YBR
2) Add this calculated field in the load statement for the BudgetEntries table:
Autonumber(Year &'|'&BU&'|'&[Responsibility Center]&'|'&[Document No],'YBR') AS %YBR
3) Then avoid including the fields Year, BU, Responsibility Center and Document No from the ItemLedgerEntries table.
4) Reload and see if the $Syn 3 Table disappeared.