topic Re: Object with all data even if the data is not directly related in QlikView

Object with all data even if the data is not directly related

Thu, 07 Jan 2016 16:10:47 GMT

Hello,

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.

For example:

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

Re: Object with all data even if the data is not directly related

kkkumar82 — Fri, 08 Jan 2016 12:10:43 GMT

Can you post any sample files with mixing the internal and external data or create a qvw file.

Thanks

Kiran Kumar

Re: Object with all data even if the data is not directly related

NareshGuntur — Fri, 08 Jan 2016 12:17:17 GMT

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?

Cheers,

Naresh

Re: Object with all data even if the data is not directly related

mightyqlikers — Fri, 08 Jan 2016 12:25:49 GMT

hi,

take a straight table and try

Regards

$@M

Re: Object with all data even if the data is not directly related

Anonymous — Fri, 08 Jan 2016 12:26:51 GMT

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.

Re: Object with all data even if the data is not directly related

effinty2112 — Fri, 08 Jan 2016 14:02:39 GMT

Hi Moreira,

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.

Good luck.

Re: Object with all data even if the data is not directly related

Tue, 12 Jan 2016 10:21:06 GMT

Hello all,

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.

Cheers