Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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

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

Tags (3)
3 Replies
Highlighted

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

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,

S

Highlighted
Creator
Creator

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

Thanks S.

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

Steve

Highlighted

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

Steve -

I am glad the issue is resolved for you.

Have a good one.

Best,

S