I am using QlikView for last one month, it is very good reporting tool. I created one data model and prepared the reports, but I am getting the duplicate data in the reports.
I have two tables TRANSACTIONS, TICKETS with below fields. I want to create data model using these two tables. Here master_doc_id as the key between these two tables.
order_no, // order number
eu_master_doc_id, // end user id
res_master_doc_id, // reseller id
master_doc_id // it can be end user id or reseller id or both
1. [TRANSACTIONS] : At order line item level eu_master_doc_id, res_master_doc_id can have different or same values
2. [TICKETS]: At ticket_id level master_doc_id can have the value which can be belong to end user id or reseller id or both
Please find the data model below for your reference. My problem is while creating the reports I am getting duplicate data.
It would be a great help.
Please let me know if you need more details.
Using the above two tables, I have created the below data model.
Data Model Script: