topic Re: Relating data not showing in QlikView

Relating data not showing

qlikmpate0 — Wed, 29 Jul 2015 09:23:13 GMT

I have a Qlikview document to show Requisitions, PO's and then the Accounts Payables. I'm missing some joins from the PO to AP as I do not get the relating AP information for a PO. I have added my document. Please can someone advise.

Thanks in advance

Re: Relating data not showing

lironbaram — Wed, 29 Jul 2015 09:55:38 GMT

the problem seems to be in the apinvdists table

it only have 29 rows in it

Re: Relating data not showing

puttemans — Wed, 29 Jul 2015 10:01:56 GMT

Hello Mina,

After checking your file, I think the issue is in the links 'Join to AP invoices D' and 'Join to PO dists I' in your APInvDists table. They show subset ratios of 0.01% and 0.05% respectively. (so basically no fit) As there is no fit, you won't see a link in your data either. This could mean that your 2 fields you're linking each time are not similar. I'd start by checking those.

Regards,

Johan

Re: Relating data not showing

avinashelite — Wed, 29 Jul 2015 10:04:06 GMT

check the join on

as [Join to PO Line Locs]

this does't have proper data

Re: Relating data not showing

qlikmpate0 — Wed, 29 Jul 2015 12:25:57 GMT

Thanks but not all data showing, do i need to do the loads differently ie reorder?

Re: Relating data not showing

qlikmpate0 — Fri, 31 Jul 2015 07:14:06 GMT

Show I load the tables differently to get the data i need?

Re: Relating data not showing

puttemans — Fri, 31 Jul 2015 07:50:22 GMT

Hello Mina,

I'd first have a look at the different variables that make up your link.

e.g. AP_Invoice_Distributions_All.PO_DISTRIBUTION_ID vs PO_Line_Locations_All.LINE_LOCATION_ID

Put theze next to each other, and compare them. Best would be to do this for a PO/AP that should be common.

This is what you defined to be the link between AP & PO, but there seems to be a very limited fit. This may be due to a format difference, even though the data are similar. In that case, you re-format one of the variables so that they match, and the link becomes much stronger. This is similar for the other link I mentioned.

Regards,

Johan

Re: Relating data not showing

avinashelite — Fri, 31 Jul 2015 09:56:09 GMT

its hard to tell ...can you please share the sample data or qvd so that we can help you out

Re: Relating data not showing

qlikmpate0 — Fri, 31 Jul 2015 12:01:07 GMT

My Ap Invoice distributions is out of sync with the other qvd's. This may be the problem, I'm just testing this now.

Re: Relating data not showing

qlikmpate0 — Mon, 03 Aug 2015 10:38:13 GMT

Hi Avinash,

Have you had a chance to have a look at the QVD's

Re: Relating data not showing

avinashelite — Mon, 03 Aug 2015 11:16:06 GMT

Hi Mina,

Really sorry, I was tied up with the lot of work ...will get back too you soon

Re: Relating data not showing

qlikmpate0 — Mon, 03 Aug 2015 11:18:30 GMT

No worries I was just wondering will wait for you to come back no apologies necessary, we are all in the same boat.

Re: Relating data not showing

qlikmpate0 — Mon, 03 Aug 2015 11:40:15 GMT

I have checked this but according to my joins this should be correct, but they don't match which I would expect or not. confused.com can you explain further

Re: Relating data not showing

qlikmpate0 — Mon, 03 Aug 2015 14:49:35 GMT

Hi all,

just to let you know I have managed to get all the information I need, I had some restrictions which I didn't need hence incorrect data returning.

Thanks for all your help, much appreciated.

regards

Mina