topic Re: Keys not joining properly (no fields from the dimension table) in QlikView

Keys not joining properly (no fields from the dimension table)

zagzebski — Tue, 17 Feb 2015 02:22:41 GMT

I have a Transaction table with the GL Account field and a GL Account table..

I have never had this happen but the fields won't join. Note the two tables below. But then when I create the chart it must not be joining because for account 10065 it WON'T pull in the Desc field. Is it something to do with the formatting of the GL Account field?

GL TABLE:

GL Account Description

10065 Cash

TRANSACTION TABLE:

GL Account Amount

10065 $100

CHART:

GL Account Desc Amount

10065 - $ 100

Thanks in Advance,

Steve

Re: Keys not joining properly (no fields from the dimension table)

sunny_talwar — Tue, 17 Feb 2015 02:39:33 GMT

When you join the two tables, do you get two rows of data (duplication of GL Account 10065)? If not, then I don't think join is an issue here. Can you share a sample document or at least your script, so it can be troubleshooted.

Best,

Re: Keys not joining properly (no fields from the dimension table)

zagzebski — Tue, 17 Feb 2015 03:06:20 GMT

Thanks S.

I actually just found the issue. I rapped both in a text() function and not they are linking appropriately.

Steve

Re: Keys not joining properly (no fields from the dimension table)

sunny_talwar — Tue, 17 Feb 2015 03:16:06 GMT

Steve -

I am glad the issue is resolved for you.

Have a good one.

Best,