Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

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

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

6 Replies
kkkumar82
Valued Contributor III

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

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

Thanks

Kiran Kumar

nareshguntur
Valued Contributor

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

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

mightyqlikers
Contributor III

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

hi,

take a straight table and try

Regards

$@M

lubicz99
Valued Contributor

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

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.

effinty2112
Honored Contributor

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

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.

Not applicable

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

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