topic Compare two different datamodels in QlikView

Compare two different datamodels

Thu, 18 Aug 2011 12:25:52 GMT

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,

Re: Compare two different datamodels

gandalfgray — Thu, 18 Aug 2011 12:42:28 GMT

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;

Compare two different datamodels

Thu, 18 Aug 2011 15:15:08 GMT

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

Compare two different datamodels

gandalfgray — Fri, 19 Aug 2011 06:44:34 GMT

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?

Compare two different datamodels

Fri, 19 Aug 2011 11:46:20 GMT

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,

Compare two different datamodels

gandalfgray — Fri, 19 Aug 2011 12:22:24 GMT

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!