I have a problem with my 2 tables for budget
1. BUDGAGE: Year / Employee / Sales
2. BUDGET: date / Material group / Sales
I have a problem of circular loop and I can't solve
Can you help me??
Hi Gennaro ,
Hope this helps you ,
Create a resident to the Document Table Say Document_New with the columns Agente and other ID if you have .
And Link the Document_New with the Agente of document . Alias the Agente in Doucument_New , BUDGAGE , AGENTI table and link these tables with the same alias . So that the loop will be resolved .
Please find the attachment for reference
Lets first start with the data/material.
What you must do is bring the amount of tables back by combining the ones that have connected information. I don't know how which data is connected but you can do this by making one table by using RESIDENT and CONCATENATE.
DROP TABLE SETTORE;
DROP TABLE BUDGET;
DROP TABLE MATERIALE;
If I am correct this will make 1 table instead of 3.
The new table has the SM fields from all 3 previous tables in 1 SM field plus all the other fields form these 3 tables.
The DROP TABLE deletes the 3 previous table after making the new table (as you don't need them anymore)
I hope this is some help for you.
What I mean is that you have to make sure that there are no $Syn tables in your table chart.
Qlikview creat those tables when there are more then 1 connection to a table (or a loop)
Let me try to explain how it works by focussing on 2 tables first.
If you take a look at your tables BUDGET and DOCUMENTI, they both have the fields "Data"and "Agente". So normaly there would be 2 lines between the 2 tables (connecting the both Date and the both Agente" fields) And because Qlikview can have one 1 connection between 2 tables it generates a $Syn table.
There are many ways to solve this, but the right way depends on what information is in the fields and how you want to link them.
The easiest way to solve this is to rename one of the 4 (2 data and 2 Agente) fields.
Change in your loadscript where you load the BUDGET table :
Agente as BudgetAgent
This way the "Data" field is the only one that is in both tables so there is only one link between the 2 tables and no $Syn table will be created
I know this is probebly not a good solution but just so you can see how it works.
Let me know if this makes any sense to you, then we can go on to the next step.
thanks for your help.
I tried with ApplyMap and this is the result
My problem is that in this I have more record in qvd than in original file. I have a record for every link of DATA, AGENTE, SM as in the table above
I attached the script
I don't want more record than file
can you help me?