I have here a big problem with lots of hours spent already.
We all know that QlikView has an associative model which is great but for this particular question, it might be a problem for me.
I will discribe my problem, and some of you can point me to other related discussions, or even offer me a solution
The scenario is the following:
We have External (for the final customer) and Internal (between sales organizations of the same company) Invoices.
This External and Internal Invoices are related to each one and it can be easely associated. This is not the problem.
The problem is that in some cases, there are external and internal invoices that should be associated but are not (have no key field in common).
My goal here is to display this invoices in an object.
OrderNum ExternalInvoice InternalInvoice Value InternalValue
--------------- ----------------------- -------------------- ---------- ----------------
123 9999 8888 541 452
321 9998 8887 489 489
231 9997 NULL 789 0
369 NULL 8885 0 15
In QlikView I can't see this last record.
Anyone has any ideia?
Thanks very much
The example you have shown above is from the same table?
where are you unable to see the last row?
What kind of chart are you using?
Often when I am troubleshooting, I use a Table Box Object and just choose all of the fields. This shows me all of the unique records in the table. In your example, you seem to show order # as a key field. Is that correct?
As mentioned above, it would be helpful to know what kind of object you are trying to create and if possible can you share a qvw with your data model.
It looks like you will a table of External Invoices and a table of Internal Invoices with a key field OrderNum. If so, if you have unmatched invoices it's not because they do not have a common field but because you have external invoices with values of the field OrderNum with no corresponding internal invoice record sharing that value in that field.
For these records if there is no common OrderNum value you would need to know what rule, if any, exists that you could use to match these up. In other words if you had an internal invoice and an external invoice on your desk in front of you with the OrderNum field obscured can you tell if they are a matching pair or not?
Unless I've misunderstood this this isn't a Qlikview problem - rather it's a problem with the source data.
first of all, thanks very much for trying to help me.
I decided to abandon this approach and I'm now creating two different objects with that shows all the informations according to what I want.