Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlikview community,
i would like to generate a diagram table which combines two different Datamodels. Unfortunately I have no idea how I can best implement. Both systems include an SAP order number. To create a link between these two systems I have determined the “order number” as a primary key. So far so good !
Foreach ordernumber for both systems is one more base identification (IMOBE ID) and an assigned month.
For better clarity, I have copied out two snapshots, showing the order number of selection in both tablediagrams.
Challenge/ Objective:
For a business requirement from a controlling department wants to compare the two sets of data and display it in a third dynamically generated table like this.
See the pics and the qvw attached here for better understanding what i want to do. I am grateful for any help and ideas.
best regards,
I think you just can concatenate. Something like this:
ControlTable:
Load HEL_CAMPAIGN_Flight Ext. ID_recordedEntry As [SAP Order No.],
[HEL_WEBSITES_Webseiten Referenznr.] As IMOBE,
[HEL_DATA_Datum > MONTH] As month,
sum([HEL_DATA_Imps mit Defaults]) As [Adserver system 2]
Resident HELIOS
Group By
HEL_CAMPAIGN_Flight Ext. ID_recordedEntry,
[HEL_WEBSITES_Webseiten Referenznr.],
[HEL_DATA_Datum > MONTH];
Concatenate(ControlTable)
Load SAP_TEAMREPORT_Auftragsnummerpos As [SAP Order No.],
SAP_TEAMREPORT_Basisbelegungseinheit As IMOBE,
Month([SAP_TEAMREPORT_E.-Dat. Von]) As month,
SAP_TEAMREPORT_Basismenge As [SAP system 1]
Resident SAP;
I think you just can concatenate. Something like this:
ControlTable:
Load HEL_CAMPAIGN_Flight Ext. ID_recordedEntry As [SAP Order No.],
[HEL_WEBSITES_Webseiten Referenznr.] As IMOBE,
[HEL_DATA_Datum > MONTH] As month,
sum([HEL_DATA_Imps mit Defaults]) As [Adserver system 2]
Resident HELIOS
Group By
HEL_CAMPAIGN_Flight Ext. ID_recordedEntry,
[HEL_WEBSITES_Webseiten Referenznr.],
[HEL_DATA_Datum > MONTH];
Concatenate(ControlTable)
Load SAP_TEAMREPORT_Auftragsnummerpos As [SAP Order No.],
SAP_TEAMREPORT_Basisbelegungseinheit As IMOBE,
Month([SAP_TEAMREPORT_E.-Dat. Von]) As month,
SAP_TEAMREPORT_Basismenge As [SAP system 1]
Resident SAP;
Thank you for your assistance.
Is there a solution approach based on a dynamic generation of the table?
i mean not during the scripttime, but by postaction macro command?
The problem is that in my data volume, the server takes a long time until the script is executed to end.
Thank you
Hi again
I guess there can be ways of doing what you want in a macro also,
but I am not sure that doing what I suggested in the Load script would add so much time to the loading.
Have you checked your logfile, is it a significant time used for the code I suggested?
Hi Gandalf,
the problem is actually my big data model. In the meantime has a size of 2 GB of reach. So I wanted to avoid further to create tables.
I would like to compare their performance between macro and script solution. But thanks to your help, I now have a solution Alternaitve how can I transpose.
Thanks again to this point.
best regards,
Hi honour
Looking at your existing table view, I doubt that the small ControlTable created by my solution would make your qvw notably larger.
Anyway, good luck!