topic Re: Linking two unlinked dimensions in QlikView

Linking two unlinked dimensions

Karl_Hart — Fri, 04 Sep 2015 11:09:00 GMT

Hi,

I'm not sure how to explain this but I'll try my best.

I have two fields that I need to keep separate in the script, for example, CustomerID and SupplierID

For multiple cases the CustomerID and SupplierID will be identical and effectively, I want to a chart to return some info from the Supplier Table when I have the CustomerID selected.

For example,

Customer Table

CustomerID 1234

Supplier Table

SupplierID 1234

Supplier Address 123 ABC Street

I want to create a straight table in the front end that will show me

CustomerID Supplier Address

1234 123 ABC Street

Is there a way I can do that using calculated dimensions or set analysis in the expressions?

Many thanks

Re: Linking two unlinked dimensions

jonathandienst — Fri, 04 Sep 2015 11:19:35 GMT

You say 'unlinked' but its not clear what you mean by that. Are they from two separate, unassociated tables?

I think you need to post more information on your data model and where you mean to use the expression. The best way is to show that in an uploaded qvw.

Re: Linking two unlinked dimensions

Karl_Hart — Fri, 04 Sep 2015 11:22:06 GMT

They are linked via a third table. Obviously the above is a simplistic version of the issue, I'll see if I can build a qvw that has the relevant info in it

Thanks