Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Compare two different datamodels

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 theorder 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,

1 Solution

Accepted Solutions
gandalfgray
Valued Contributor

Re: Compare two different datamodels

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;

5 Replies
gandalfgray
Valued Contributor

Re: Compare two different datamodels

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;

Not applicable

Compare two different datamodels

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

gandalfgray
Valued Contributor

Compare two different datamodels

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?

Not applicable

Compare two different datamodels

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,

gandalfgray
Valued Contributor

Compare two different datamodels

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!

Community Browser