topic Re: Code not linked in QlikView

Code not linked

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

I am get confused that why Am not getting bud vs Act data in one line against GL code. where GL codes present in both tables .

Thanks

Re: Code not linked

sunny_talwar — Fri, 20 Jan 2017 10:37:46 GMT

May be use GL_CODE_LINK as your dimension?

Re: Code not linked

stabben23 — Fri, 20 Jan 2017 11:01:42 GMT

Do as Sunny describe, but you have a lot of "mismatched" account in there.

Re: Code not linked

asgardd2 — Fri, 20 Jan 2017 11:03:24 GMT

I think, that you have a mistake in the script.

In first load you was create two same fields with different names.

Re: Code not linked

stabben23 — Fri, 20 Jan 2017 11:09:47 GMT

But thats the key for concatenate the tables, nothing wrong With that.

But EntryNo have nothing common and should not be concatenated With the same name.

Re: Code not linked

stabben23 — Fri, 20 Jan 2017 11:19:55 GMT

Ok, I'll think I see why you have some mismatches here, you only load First 5000 rows.

But have a look at EntryNo, as it is right now and you Select a EntryNo you will get total mismatch on Accontfields from Budget and GL_Entry. Rename the Field if its not a common key.

Re: Code not linked

asgardd2 — Fri, 20 Jan 2017 11:45:12 GMT

I mean,that mistake in second table There are not field GLAcc-Code in second load, consequently we can see 2 rows in chart. (because value in second row is null)

Re: Code not linked

stabben23 — Fri, 20 Jan 2017 11:57:10 GMT

Hmm, This is normally used when you test Your data. When you concatenate you need to have common keys in this case GL_CODE_LINK.

GLAcc_Code is to know that this account is from GL_Entry table

Budget_Acc to know which account who is from Budget table.

You could use Flag but sometimes it could be greate to see the keyvalue from both tables.

These Fields could be droped or commet awy later on.

You will always have 2 rows on the accont when concatenate otherwise you need to join. But in this case concatenate is the correct way.

If he shows correct Dimension GL_CODE_LINK it will be one row in the chart.

Re: Code not linked

asgardd2 — Fri, 20 Jan 2017 12:08:18 GMT

Yes, thank you for your explanation, I understand what you mean.